有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 category=’ROCK’