Q. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;
SELECT *
FROM employee
WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;
β
Correct Answer: (A)
All employees details between 2007 and 2008
Explanation: This MySQL statement uses the BETWEEN operator to filter data from the 'employee' table.