检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是（）。
A: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ( SELECT GRADE FORM SC WHERE CNO='C2' );
B: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE IN ( SELECT GRADE FORM SC WHERE CNO='C2' );
C: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE NOT IN ( SELECT GRADE FORM SC WHERE CNO='C2' );
D: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ALL ( SELECT GRADE FORM SC WHERE CNO='C2' );
A: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ( SELECT GRADE FORM SC WHERE CNO='C2' );
B: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE IN ( SELECT GRADE FORM SC WHERE CNO='C2' );
C: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE NOT IN ( SELECT GRADE FORM SC WHERE CNO='C2' );
D: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ALL ( SELECT GRADE FORM SC WHERE CNO='C2' );
举一反三
- 检索选修了课程”C1”的学生中成绩最高的学生的学号，正确的SELECT语句为（ ） A: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >=ALL (SELECT Grade FROM SC WHERE Cno=’C1’); B: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE IN (SELECT Grade FROM SC WHERE Cno=’C1’); C: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE > ANY (SELECT Grade FROM SC WHERE Cno=’C1’); D: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >= (SELECT Grade FROM SC WHERE Cno=’C1’);
- 检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是 。 A: SELECT S＃ FORM SC WHERE C＃='C2' AND GRADE >= (SELECT GRADE FORM SC WHERE C＃='C2') B: SELECT S＃ FORM SC WHERE C＃='C2' AND GRADE IN (SELECT GRADE FORM SC WHERE C＃='C2') C: SELECT S＃ FORM SC WHERE C＃='C2' AND GRADE NOT IN (SELECT GRADE FORM SC WHERE C＃='C2') D: SELECT S＃ FROM SC WHERE C＃='C2' AND GRADE >=ALL (SELECT GRADE FROM SC WHERE C＃='C2')
- 检索选修课程"C2”的学生中成绩最高的学生的学号，正确的SELECT语句是______。 A: SELECT S# FORM SC WHERE C#="C2"AND GRADE＞=(SELECT GRADE FORM SC WHERE C#="C2") B: SELECT S# FORM SC WHERE C#="C2"AND GRADE IN(SELECT GRADE FORM SC) WHERE C#="C2" C: SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2") D: SELECT S# FORM SC WHERE C#="C2"AND GRADE＞=ALL(SELECT GRADE FORM SC WHERE C#="C2")
- 查询所有有成绩的学生学号和课程号。正确的SELECT语句是（）。 A: Select sno , cno from sc where grade < > null B: Select sno as 学号, cno as 课程号 from sc where grade is not null C: Select sno , cno from sc where grade !=‘ ’ D: Select sno , cno from sc where grade is not null
- 检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是: SELECT S# FROM SC WHERE C#=“C2” AND GRADE IN (SELECT GRADE FROM SC WHERE C#=“C2”)|SELECT S# FROM SC WHERE C#=“C2” AND GRADE NOT IN (SELECT GRADE FROM SC WHERE C#=“C2”)|SELECT S# FROM SC WHERE C#=“C2” AND GRADE＞＝ (SELECT GRADE FROM SC WHERE C#=“C2”)|SELECT S# FROM SC WHERE C#=“C2” AND GRADE＞＝ALL (SELECT GRADE FROM SC WHERE C#=“C2”)