C-06-Q068mediumsingle_mcq
Which query retrieves students that are in Class 8, 9 or 10?
Which query retrieves students that are in Class 8, 9 or 10?
- a
SELECT * FROM student WHERE class IN (8, 9, 10); - b
SELECT * FROM student WHERE class = 8, 9, 10; - c
SELECT * FROM student WHERE class BETWEEN 8 10; - d
SELECT * FROM student WHERE class = (8 9 10);