Q. What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’;
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’;
β
Correct Answer: (A)
Only those employees are selected whose first name started with 'F'
Explanation: This question is about selecting data from a table named "employee" using a specific condition. Let's break it down: