MySQL Database MCQs - CSE MCQs Questions and Answers

Home / CSE MCQs / MySQL Database MCQs :: Discussion

What will be the output of the following query?

SELECT emp_id, fname, lname

FROM employee

WHERE LEFT (fname, 1) ='F' OR LEFT (lname, 1) ='F';

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

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

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

None of the mentioned

Answer : Option A

Explanation :

Be The First To Comment

Comments

Name