> > >

MySQL MCQs

How would you write a query to select all orders that contain either 3, 5, 7 or 9 items?

SELECT * FROM orders WHERE LIMIT item_count (3, 5, 7, 9);

SELECT * FROM orders WHERE item_count IN (3, 5, 7, 9);

SELECT * FROM orders WHERE item_count LIKE (3, 5, 7, 9);

SELECT * FROM orders WHERE item_count = (3, 5, 7, 9);

Answer

Correct Answer: SELECT * FROM orders WHERE item_count IN (3, 5, 7, 9);

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it