针对学生表Student(Sno,Sname, Ssex,Sage,Sdept)。要检索学生表中年龄在17至25岁之间(包括17和25)的学生的姓名及年龄,SQL语句正确的是
举一反三
- 针对学生表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)。要检索学生表中年龄在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为系别。要检索学生表中年龄在16至30岁之间(包括16和30)的学生的姓名及年龄,SQL语句正确的是()。
- 【多选题】针对学生表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),其中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;