从“选课”表巾检索成绩大于等于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
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
举一反三
- 下列各题使用如下数据表: 学生.DBF:学号(C,8),姓名(C,6),性别(C,2) 选课.DBF:学号(C,8),课程号(C,3),成绩(N,3) 从“选课”表中检索成绩大于等于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
- ~(35)题使用如下数据表:学生.DBF:学号(C,8)姓名(C,6),性别(C,2)选课.DBF:学号(C,8),课程号(C,3),成绩(N,3)从“选课”表中检索成绩大于等于60并且小于90的记录信息,正确的SQL命令是()。 A: SELECT*FROM选课WHERE成绩BETWEEN 60 AND 89 B: SELECT*FROM选课WHERE成绩BETWEEN 60 T0 89 C: SELECT*FROM选课WHERE成绩BETWEEN 60 AND 90 D: SELECT*FROM选课WHERE成绩BETWEEN 60 TO 90
- (31)~(35)题使用如下数据表: 学生.DBF:学号(C,8),姓名(C,6),性别(C,2) 选课.DBF:学号(C,8),课程号(C,3),成绩(N,3) 从“选课”表中检索成绩大于等于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
- 第31~35题使用如下数据表: 学生.DBF:学号(C,8),姓名(C,6),性别(C,2) 选课.DBF:学号(C,8),课程号(C,3),成绩(N,3) 从“选课”表中检索成绩大于等于60并且小于90的记录信息,正确的SQL命令是()。 A: 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
- 从“选课”表中检索成绩大于等于60并且小于90的记录信息(成绩是整数),正确的SQL命令是()。 A: SELECT*FROM选课WHERE成绩BETWEEN60AND89 B: SELECT*FROM选课WHERE成绩BETWEEN60TO89 C: SELECT*FROM选课WHERE成绩BETWEEN60AND90 D: SELECT*FROM选课WHERE成绩BETWEEN60TO90