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

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

(A) Only those employees are selected whose first name started with 'F'
(B) Only those employees are selected whose first name started with other than 'F'
(C) All of the mentioned
(D) None of the mentioned

💬 Discuss

✅ 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:

Published by Priyanka Tomar ⭐ 35.28K Points at 22-Mar-2025 12:43 pm in MySQL

Explanation by: Priyanka Tomar

This question is about selecting data from a table named "employee" using a specific condition. Let's break it down:

💬 Discussion

📊 Question Analytics

👁️

109

Total Visits

📽️

1 y ago

Published

🎖️

Priyanka Tomar

Publisher

📈

96%

Success Rate