单项选择题

在SQL Server 2000中，查询表STUDENT1中所有成绩在300～320的学生。在查询分析器中应执行______

A．SELECT * FROM STUDENT1 WHERE CJ＞300 AND CJ＜320
B．SELECT * FROM STUDENT1 WHERE CJ BETWEEN 310 AND 320
C．SELECT * FROM STUDENT1 WHERE CJ BETWEEN 300 AND 320
D．以上都不对

<上一题目录下一题>

热门试题

单项选择题

在Visual FoxPro中，KC表中KH字段为三位，显示KC表中KH数的第二位是2的所有课程的记录。在命令窗口应执行______

A．SELECT * FROM KC WHERE KH LIKE "2%"
B．SELECT * FROM KC WHERE KH LIKE "_2_"
C．SELECT * FROM KC WHERE KH LIKE "%2"
D．以上都不是

单项选择题

在SQL Server 2000中，查询表STUDENT1中所有李姓的学生。在查询分析器中应执行______

A．SELECT * FROM STUDENT1 WHERE XM LIKE "李"
B．SELECT * FROM STUDENT1 WHERE XM LIKE "李%"
C．SELECT * FROM STUDENT1 WHERE XM IS "李%"
D．以上都不是