A

Admin • 833K Points
Coach

Q. What will be the output of the following MySQL command?
SELECT emp_id, fname, lname
FROM employee
WHERE title=’HEAD TELLER’ AND start_date=2008-11-24;

  • (A) All columns
  • (B) condition value
  • (C) Columns mention with "SELECT" clause and only those rows which contain 'HEAD TELLER' as a "title" and start_date as 2008-11-24
  • (D) None of the mentioned
  • Correct Answer - Option(C)
  • Views: 25
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This question is about understanding how the SELECT statement works in MySQL. Let's break it down:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.