题目内容

查询非计算机系中比计算机系中年龄最小者年龄大或相等的学生姓名，不正确的查询语句是：

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 Student S1WHERE EXISTS (SELECT FROM Student S2WHERE S2.Sdept = 'CS'AND S1.Sage >= S2.Sage)AND Sdept != 'CS';
C. SELECT SnameFROM StudentWHERE Sage >= (SELECT MIN(Sage) FROMStudentWHERE Sdept = 'CS')AND Sdept != 'CS';
D. SELECT SnameFROM StudentWHERE Sage >= ANY (SELECT SageFROM StudentWHERE Sdept = 'CS')AND Sdept != 'CS';

查看答案

搜索结果不匹配？点我反馈

更多问题

在所有学生中查询比计算机系所有学生年龄都要大的学生姓名，不正确的查询语句是：

A. SELECT SnameFROM StudentWHERE Sage > (SELECT MAX(Sage)FROM StudentWHERE Sdept = 'CS');
B. SELECT SnameFROM StudentWHERE Sage > ALL (SELECT SageFROM StudentWHERE Sdept = 'CS');
C. SELECT SnameFROM Student S1WHERE EXISTS (SELECT SageFROM Student S2WHERE Sdept = 'CS'AND S1.Sage > S2.Sage);
D. SELECT SnameFROM Student S1WHERE NOT EXISTS (SELECT SageFROM Student S2WHERE Sdept = 'CS'AND S1.Sage <= S2.Sage);

查看答案