Question:You have two tables emp_1 and emp_2, having the following data:

Table emp_1

Name                Date
Robert               1/5/2008
John                    1/6/2008
Michael                1/7/2008
Rachael                1/10/2008
Joey                    1/10/2008

Table emp_2

Name                Date
Lewis                1/05/2008
David                1/07/2008
George               1/11/2008
Jerry                 1/12/2008
Monica                1/12/2008

The following query is run in the Query Analyzer:

SELECT Date FROM emp_1
EXCEPT
SELECT Date FROM emp_2

What will be the result of the query? 

A 1/6/2008, 1/10/2008, 1/11/2008, 1/12/2008 
B 1/6/2008, 1/10/2008, 1/10/2008 
C 1/6/2008, 1/10/2008, 1/11/2008, 1/12/2008, 1/12/2008 
D 1/6/2008, 1/10/2008 
E The query will give an error as EXCEPT is only concerned with varchar values 

+ Answer
D 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description