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

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

Explanation by: Admin

This MySQL command is used to retrieve information from a table called "employee".

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.