πŸ“Š MySQL
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:

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

πŸ‘οΈ
98
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Priyanka Tomar
Publisher
πŸ“ˆ
96%
Success Rate