A

Admin • 833K Points
Coach

Q. What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (lname, 1) =’F’;

  • (A) Only those employees are selected whose last name started with 'F'
  • (B) Only those employees are selected whose last name started with other than 'F'
  • (C) All of the mentioned
  • (D) None of the mentioned
  • Correct Answer - Option(A)
  • Views: 21
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This MySQL statement is used to retrieve information about employees from a table called "employee".

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.