针对学生表Student(Sno,Sname, Ssex,Sage,Sdept),其中sno为学号,sname为姓名,ssex为性别,sage为年龄,sdept为系别。要检索学生表中年龄在16至30岁之间(包括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 >;= 16 and Sage<;= 30
D: Select Sname, Sage From Student Where Sage >;= 16 or Sage<;= 30
发布时间:2024-05-07 19:20:28