-
What will be the output of the query given below?
SELECT *
FROM employee
WHERE (title=’HEAD TELLER’) OR (start_date > 2013-01-24);
-
- All rows belong to table employee
- All columns and rows belong to table employee
- All columns but only those rows which contain ‘HEAD TELLER’ as a “title” OR start_date are greater than 2013-01-24
- All of above
- None of these
Correct Option: C
“WHERE” clause is used to filter out unwanted rows therefore in above query only those rows will be selected which contain title as ‘HEAD TELLER’ OR start_date is greater than 2013-01-24.