Q. What will be the output of the following MySQL command?
SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);
SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);
β
Correct Answer: (B)
All columns but only those rows which contain 'HEAD TELLER' as a "title" and 2013-01-24 as a "start_date"
Explanation: This question is about understanding how the WHERE clause works in MySQL.