S

Sonali Mishra • 4.53K Points
Extraordinary

Q. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE start_date>=’2007-01-01’ AND
Start_date<=’2005-01-01’

(A) All employees between 2007 and 2005
(B) All employees from 2007 to 2005
(C) Empty set
(D) None of the mentioned

Correct Answer - Option(D)
Views: 16
Filed under category MySQL

Explanation by: Sonali Mishra

This question asks about a MySQL query that tries to find employees who started working between January 1st, 2007, and January 1st, 2005.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Question analytics