C-06-Q074mediumsingle_mcq
Which query is equivalent to SELECT * FROM student WHERE class = 8 OR class = 9 OR class = 10;?
Which query is equivalent to SELECT * FROM student WHERE class = 8 OR class = 9 OR class = 10;?
- a
SELECT * FROM student WHERE class BETWEEN 8 10; - b
SELECT * FROM student WHERE class IN (8, 9, 10); - c
SELECT * FROM student WHERE class = (8, 9, 10); - d
SELECT * FROM student WHERE class HAS (8, 9, 10);