从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

如果有学生表student，sno代表学号，sage代表年龄，则想要得到年龄在18到20之间的学生学号的SQL语句是（） A: SELECT sno<br/>FROM student<br/>WHERE sage&gt;18 or sage&lt;20 B: SELECT sno<br/>FROM student<br/>WHERE sage=18 C: SELECT sno<br/>FROM student<br/>WHERE sage in (18,20) D: SELECT sno<br/>FROM student<br/>WHERE sage between18 and 20

计算机系年龄最大的学生的信息select *from studentwhere __________________________________ A: sdept='计算机系' and sage=(select max(sage) from student where sdept='计算机系') B: sdept='计算机系' and sage=max(sage) C: sdept='计算机系' or sage=(select max(sage) from student ) D: sdept='计算机系' or sage=max(sage)

在所有学生中查询比计算机系学生平均年龄大的学生姓名，可以使用的查询语句是： A: SELECT Sname FROM Student WHERE Sage > ( SELECT AVG(Sage) FROM Student ); WHERE Sdept = 'CS' B: SELECT Sname FROM Student WHERE Sage > AVG( SELECT Sage FROM Student WHERE Sdept = 'CS' ); C: SELECT Sname FROM Student WHERE Sage > ( SELECT AVG(Sage) FROM Student WHERE Sdept = 'CS' ); D: SELECT Sname FROM Student WHERE AVG(Sage) > ( SELECT Sage FROM Student WHERE Sdept = 'CS' );

现要利用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

对教材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'))

现要利用Student表查询年龄最小的学生姓名和年龄。下列实现此功能的查询语句中，正确的是（）。 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

现要利用Student表查询年龄最小的学生的姓名和年龄。下列实现此功能的查询语句中，正确的是______。 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

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

使用教学（STC）数据库，与如下查询语句等价的是（ ）。 SELECT *FROM Student WHERE Sdept = 'CS' EXCEPT SELECT * FROM Student WHERE Sage <= 19; A: SELECT * FROM Student WHERE Sdept = 'CS' AND Sage > 19 B: SELECT * FROM Student WHERE Sdept = 'CS' AND Sage <= 19 C: SELECT * FROM Student WHERE Sdept = 'CS' OR Sage <= 19 D: SELECT * FROM Student WHERE Sdept = 'CS' OR Sage > 19