从“选课”表巾检索成绩大于等于60并且小于90的记录信息(成绩是整数),正确的SQL
题型:单项选择题
问题:
从“选课”表巾检索成绩大于等于60并且小于90的记录信息(成绩是整数),正确的SQL命令是______。
A.SELECT*FROM选课WHERE成绩BETWEEN 60 AND 89
B.SELECT*FROM选课WHERE成绩BETWEEN 60 TO 89
C.SELECT*FROM选课WHERE成绩BETWEEN 60 AND 90
D.SELECT*FROM选课WHERE成绩BETWEEN 60 TO 90