针对学生表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
发布时间:2024-05-07 19:20:28