Q. What will be the output of the following MySQL command?
SELECT emp_id, fname, lname
FROM employee
WHERE title=’HEAD TELLER’;
SELECT emp_id, fname, lname
FROM employee
WHERE title=’HEAD TELLER’;
β
Correct Answer: (C)
Columns mention with "SELECT" clause and only those rows which contain 'HEAD TELLER' as a "title"
Explanation: This MySQL command is used to retrieve information from a table called "employee".