S

Sandhya Thakur • 4.08K Points
Extraordinary

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: 12
Filed under category MySQL

Explanation by: Sandhya Thakur

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.

Question analytics