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
举一反三
- 在所有学生中查询比计算机系学生平均年龄大的学生姓名，可以使用的查询语句是： 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' );
- 对教材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'))
- 在所有学生中查询比计算机系所有学生年龄都要大的学生姓名,正确的查询语句是___________________。 A: SELECT Sname FROM Student WHERE Sage > ( SELECT MAX(Sage) FROM Student WHERE Sdept = 'CS'); B: SELECT Sname FROM Student WHERE Sage > ALL ( SELECT Sage FROM Student WHERE Sdept = 'CS'); C: SELECT Sname FROM Student S1 WHERE EXISTS ( SELECT Sage FROM Student S2 WHERE Sdept = 'CS' AND S1.Sage > S2.Sage); D: SELECT Sname FROM Student S1 WHERE NOT EXISTS ( SELECT * FROM Student S2 WHERE Sdept = 'CS' AND S1.Sage <= S2.Sage);
- 查询所有非计算机系学生的信息，不正确的SQL语句是：（ ） A: SELECT * FROM Student WHERE Sdept != 'CS'; B: SELECT * FROM Student WHERE NOT Sdept = 'CS'; C: SELECT * FROM Student WHERE Sdept IN ('MA', 'IS'); D: SELECT * FROM Student WHERE NOT Sdept IN ('CS');
- 查询语句 SELECT * FROM Student WHERE Sdept =...Sage <= 19; 可以等价为：（
内容
- 0
选择题：在所有学生中查询比计算机系学生平均年龄大的学生姓名，可以使用的查询语句是： A: SELECT SnameFROM StudentWHERE Sage >; (SELECT AVG(Sage)FROM Student);WHERE Sdept = 'CS' B: SELECT SnameFROM StudentWHERE Sage >; AVG(SELECT SageFROM StudentWHERE Sdept = 'CS'); C: SELECT SnameFROM StudentWHERE Sage >; (SELECT AVG(Sage)FROM StudentWHERE Sdept = 'CS'); D: SELECT SnameFROM StudentWHERE AVG(Sage) >; (SELECT SageFROM StudentWHERE Sdept = 'CS');
- 1
计算机系年龄最大的学生的信息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)
- 2
查询非计算机科学系中比计算机科学系所有学生年龄都小的学生姓名及年龄。 SELECT Sname,Sage FROM Student WHERE Sage [ ALL (SELECT Sage FROM Student WHERE Sdept= 'CS' ) AND Sdept <] ' CS '; 其中的Sage < ALL等价于？ A: MIN(Sage) B: MAX(Sage) C: MIN(Sage) D: MAX(Sage)
- 3
选择题：在所有学生中查询比计算机系学生平均年龄大的学生姓名，可以使用的查询语句是： A: SELECT SnameFROM StudentWHERE Sage > (SELECT AVG(Sage)FROM Student);WHERE Sdept = 'CS' B: SELECT SnameFROM StudentWHERE Sage > AVG(SELECT SageFROM StudentWHERE Sdept = 'CS'); C: SELECT SnameFROM StudentWHERE Sage > (SELECT AVG(Sage)FROM StudentWHERE Sdept = 'CS'); D: SELECT SnameFROM StudentWHERE AVG(Sage) > (SELECT SageFROM StudentWHERE Sdept = 'CS');
- 4
查询非计算机系中比计算机系中年龄最小者年龄大或相等的学生姓名，不正确的查询语句是： A: SELECT SnameFROM Student S1WHERE NOT EXISTS (SELECT *FROM Student S2WHERE S2.Sdept = 'CS'AND S1.Sage ;= S2.Sage)AND Sdept != 'CS'; B: SELECT SnameFROM StudentWHERE Sage >;= (SELECT MIN(Sage) FROMStudentWHERE Sdept = 'CS')AND Sdept != 'CS'; C: SELECT SnameFROM StudentWHERE Sage >;= ANY (SELECT SageFROM StudentWHERE Sdept = 'CS')AND Sdept != 'CS';