【单选题】有Oracle表”cd”,它包含属性”cdcode”,”category”和”cdname”,要查询category取值为”CLASSIC”或”ROCK”的行,采用语句( ) 。
A.
SELECT * FROM cd WHERE category IN ('CLASSIC','ROCK');
B.
SELECT * FROM cd WHERE category BETWEEN 'CLASSIC' AND 'ROCK';
C.
SELECT * FROM cd WHERE category='CLASSIC' AND category='ROCK';
D.
SELECT * FROM cd WHERE category='CLASSIC' OR ='ROCK';