πŸ“Š MySQL
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

πŸ‘οΈ
100
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Vinay
Publisher
πŸ“ˆ
90%
Success Rate