• 2021-04-14
    与查询语句select * from student where sage> (select max(sage) from student where ssex='女')等价的是( )。
  • C

    举一反三

    内容

    • 0

      查询语句 SELECT * FROM Student WHERE Sdept =...Sage <= 19; 可以等价为:(

    • 1

      对教材79页学生表的查询,若描述条件‘年龄大于计算机系某个学生的年龄’,可以表示为: A: WHERE sage>ANY(SELECT sage FROM student WHERE sdept='CS') B: WHERE sage>SOME(SELECT sage FROM student WHERE sdept='CS') C: WHERE sage>ALL(SELECT sage FROM student WHERE sdept='CS') D: WHERE sage>(SELECT MIN(sage) FROM student WHERE sdept='CS'))

    • 2

      现要利用Student(sno, sname, ssex, sage, sdept)表查询年龄最小的学生的姓名和年龄。下列实现此功能的查询语句正确的是( )。 A: SELECT sname, Min( sage )from student B: SELECT sname ,sage from student where sage=Min( sage ) C: SELECT TOP 1 Sname , Sage From student D: SELECT TOP 1 sname , sage from student order by sage

    • 3

      针对学生表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

    • 4

      从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