What will be the output of the following MySQL statement? SELECT * FROM employee WHERE start_date>=’2007-01-01’ AND Start_date<=’2005-01-01’ - MySQL MCQs

Q. What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE start_date>=’2007-01-01’ AND
Start_date<=’2005-01-01’

(A) All employees between 2007 and 2005
(B) All employees from 2007 to 2005
(C) Empty set
(D) None of the mentioned

💬 Discuss

✅ Correct Answer: (D) None of the mentioned

Explanation: This question asks about a MySQL query that tries to find employees who started working between January 1st, 2007, and January 1st, 2005.

Published by Sonali Mishra ⭐ 4.53K Points at 22-Mar-2025 12:45 pm in MySQL

Explanation by: Sonali Mishra

This question asks about a MySQL query that tries to find employees who started working between January 1st, 2007, and January 1st, 2005.

💬 Discussion

📊 Question Analytics

👁️

88

Total Visits

📽️

1 y ago

Published

🎖️

Sonali Mishra

Publisher

📈

84%

Success Rate