Q. 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 2013-01-24 as a "start_date"
  • (C) All rows belong to table employee
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… 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.
Explanation by: Vinay
This question is about understanding how the WHERE clause works in MySQL.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
122
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Vinay
Publisher
πŸ“ˆ
94%
Success Rate