在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的学生.在查询分析器中应执行( )
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