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’;

Question

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

Admin · Accepted Answer

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

Admin · Answer

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

Admin · Answer

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

Admin · Answer

None of the mentioned

Q. 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’;

Explanation by: Admin

Discusssion

Q. 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’;

Explanation by: Admin

Discusssion

Q. 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’;