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

  • (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
πŸ’¬ Discuss
βœ… Correct Answer: (A) Only those employees are selected whose first name and last name started with 'F'
Explanation: This MySQL statement is designed to select employee information based on their first and last names. Let's break down the code:
Explanation by: Bhagwan Das
This MySQL statement is designed to select employee information based on their first and last names. Let's break down the code:

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
117
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Bhagwan Das
Publisher
πŸ“ˆ
99%
Success Rate