Que: What will be the output of the following MySQL command?

SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) AND (start_date>2013-01-24);
a. All columns and rows belong to table employee
b. All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and start_date are greater than 2013-01-24
c. All rows belong to table employee
d. None of the mentioned
Answer: All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and start_date are greater than 2013-01-24

Leave a Comment