如果有学生表student，sno代表学号，sage代表年龄，则想要得到年龄在18到20之间的学生学号的SQL语句是（）
A: SELECT sno
FROM student
WHERE sage>18 or sage<20
B: SELECT sno
FROM student
WHERE sage=18
C: SELECT sno
FROM student
WHERE sage in (18,20)
D: SELECT sno
FROM student
WHERE sage between18 and 20
A: SELECT sno
FROM student
WHERE sage>18 or sage<20
B: SELECT sno
FROM student
WHERE sage=18
C: SELECT sno
FROM student
WHERE sage in (18,20)
D: SELECT sno
FROM student
WHERE sage between18 and 20
举一反三
- 针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在17至25岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是（ ）。 A: Select Sname, Sage From Student Where Sage between 16 and 30; B: Select Sname, Sage From Student Where Sage >= 16and Sage<= 30; C: Select * From Student Where Sage between 16 and 30; D: Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30;
- 针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)。要检索学生表中年龄在17至25岁之间（包括17和25）的学生的姓名及年龄，SQL语句正确的是（ ）。 A: Select * From Student Where Sage between 17 and 25 B: Select Sname, Sage From Student Where Sage between 17 and 25 C: Select Sname, Sage From Student Where Sage >= 17 and Sage<= 25 D: Select Sname, Sage From Student Where Sage >= 17 or Sage<= 25
- 【多选题】针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)，其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。要检索学生表中年龄在17至25岁之间（包括16和30）的学生的姓名及年龄，SQL语句正确的是()。 A. Select * From Student Where Sage between 16 and 30 B. Select Sname, Sage From Student Where Sage between 16 and 30 C. Select Sname, Sage From Student Where Sage >= 16and Sage<= 30 D. Select Sname, Sage From Student Where Sage >= 16 or Sage<= 30
- 针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)。要检索学生表中年龄在17至25岁之间（包括17和25）的学生的姓名及年龄，SQL语句正确的是（ ）。 A: Select * From Student Where Sage between 17 and 25 B: Select Sname, Sage From Student Where Sage between 17 and 25 C: Select Sname, Sage From Student Where Sage >= 17 and Sage<= 25 D: Select Sname, Sage From Student Where Sage >= 17 or Sage<= 25
- 从Student表检索年龄为20岁的学生信息，已知年龄字段是数值类型，最规范的SQL语句是( )。 A: Select * From Student where Sage=20 B: Select * From Student where Sage='20' C: Select * From Student where Sage=【20】 D: Select * From Student where Sage EQUAL 20