Examveda
Examveda

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

A. Only those employees are selected whose first name and last name started with 'F'

B. Only those employees are selected whose first name started with 'F' but last name can be starts with any other letter

C. Only those employees are selected whose first name and last name started with any other letter except 'F'

D. None of the mentioned

Answer: Option A


This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous