WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;
A. All employees details between 2007 and 2008
B. All employees details before 2008
C. All employees details from 2007 to 2008
D. Both a. and c.
Answer:A
WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;
A. All employees details between 2007 and 2008 B. All employees details before 2008 C. All employees details from 2007 to 2008 D. Both a. and c.
Explanation: “BETWEEN” operator is used for upper – upper limit.