ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;

Answer & Solution
Correct Answer: Option A
This MySQL statement uses the BETWEEN operator to filter data from the 'employee' table.

The statement is:

SELECT * FROM employee WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’

This means it will select all rows (SELECT *) from the 'employee' table where the 'start_date' column value is between '2007-01-01' and '2008-01-01', including both dates.

Therefore, the correct answer is Option C: All employees details from 2007 to 2008.

Let me know if you have any other MySQL questions!
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.