What will be the output of the following MySQL statement?

SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (lname, 1) =’T’;

Solution (By Examveda Team)

This MySQL statement is designed to find employees whose last names start with the letter "T". Let's break it down:

SELECT emp_id, fname, lname
This part tells MySQL what information to retrieve from the database. It will select the employee's ID (emp_id), first name (fname), and last name (lname).

FROM employee
This specifies the table from which the data should be taken. In this case, it's the "employee" table.

WHERE LEFT(lname, 1) = 'T'
This is the filter. It's like saying, "Only select rows where the first letter of the last name (lname) is equal to 'T'".

Let's analyze the options:

Option A: Only those employees are selected whose last name started with 'T' - This is correct because the WHERE clause filters the results to only include employees whose last names begin with 'T'.

Option B: Only those employees are selected whose last name started with other than 'T' - This is incorrect because the WHERE clause specifically looks for a 'T' as the first letter.

Option C: All of the mentioned - This is incorrect because only Option A is correct.

Option D: None of the mentioned - This is incorrect because Option A is correct.

Therefore, the correct answer is Option A. This query will select only those employees whose last name starts with the letter 'T'.