在SQL Server 2000中,查询表STUDENTl中所有成绩在300～320的学生.在查询分析器中应执行（ ）
A、SELECT*FROM STUDENTl WHERE CJ>300 AND CJ<320
B、SELECT*FROM STUI)ENTlWttERE:CJ BETWEEN 3lO AND 320
C、SELECT*FROM STUDENTIWHERE CJ BETWEEN 300 AND 320
D、以上都不对
【正确答案】：C
【题目解析】：在SQL Server 2000中,查询表STUDENTl中所有成绩在300～320的学生.在查询分析器中应执行SELECT*FROM STUDENTIWHERE CJ BETWEEN 300 AND 320
