A

Admin • 833K Points
Coach

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’;

  • (A) All employees details between 2007 and 2008
  • (B) BALANCE TABLE
  • (C) All employees details from 2007 to 2008
  • (D) None of the mentioned
  • Correct Answer - Option(A)
  • Views: 24
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This MySQL statement uses the BETWEEN operator to filter data from the 'employee' table.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.