• 2022-06-07
    有学生信息表student,求年龄在20岁到22岁之间(含20岁和22岁)的学生姓名和年龄的 SQL语句是: SELECT sname, age FROM student WHERE age ______;
  • BETWEEN 20 AND 22 或者 age≤22 AND age≥20 或者 age≥20 AND age≤22

    内容

    • 0

      关系模式:Student(Sno, Sname, Age),其中Sno、Sname、Age分别表示学生的学号、姓名和年龄。“查询年龄大于20岁的学生姓名”的关系代数表达式是() A: σSname(σage>20(Student)) B: ΠSname(σage>20(Student)) C: σSname(Πage>20(Student)) D: ΠSno(σage>20(Student))

    • 1

      查询年龄不在20到23岁之间的学生的信息,所使用的语法命令为() A: select * from student where age not between 20 and 23 B: select * from student where age between 20 and 23 C: select * from student where age not between 20 to 23 D: select * from student where not age from 20 to 23

    • 2

      查询年龄在20到23岁之间的学生的信息,所使用的语法命令为() A: select * from student where age between 20 to 23 B: select * from student where age from 20 to 23 C: select * from student where age between 20 and 23 D: select * from student

    • 3

      数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据,下列哪个SQL语句是正确的?() A: Select* From Student Where Age>=20 ANDAge>=30 B: Select* From Student Where Age>=20 ANDAge<=30 C: Select* From Student Where Age BET WENN 20AND30 D: Select* From Student Where Age>=20&&Age>=30&quot

    • 4

      已知学生表student(sid,sname,sex,age0,其各个属性分别表示学号、姓名、性别和年龄,若要从表中检索所有学生的信息,检索结果按年龄由大到小排序,下列SQL语句正确的是( ) A: select * from student order by age B: select * from student group by age C: select * from student order by age desc D: select * from student group by age desc