下列SQL语句中，正确的是（ ）。 A: SELECT S B: , SNAME FROM SC GROUP BY S C: D: SELECT S E: FROM SC GROUP BY S F: HAVING COUNT(*)>3 G: SELECT S H: ,Cname FROM SC GROUP BY S I: WHERE COUNT(*)>3 J: SELECT S K: FROM SC WHERE COUNT(*)>3 GROUP BY S L:

检索选修了课程”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’);

在学生选课数据库中，查询平均成绩大于等于60分的同学，SQL语句为（ ） A: SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING AVG(Grade)>=60; B: SELECT Sno FROM SC WHERE Grade>=60 GROUP BY Sno; C: SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG(Grade)>=60; D: SELECT Sno FROM SC GROUP BY Sno HAVING Grade >=60;

查询最低成绩大于85分的学生学号和平均成绩,可以使用的查询语句是:　 。 A: SELECT Sno, AVG(Grade) FROM SC HAVING MIN(Grade) > 85 GROUP BY Sno; B: SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING MIN(Grade) > 85; C: SELECT Sno, AVG(Grade) FROM SC WHERE MIN(Grade) > 85 GROUP BY Sno; D: SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno WHERE MIN(Grade) > 85;

针对学生选课表sc（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下（ ）语句可查询选修了两门以上成绩在90分以上课程的学生学号。 A: select sno from sc where grade>90 group by sno having count(cno)>2; B: select sno from sc where grade>90 group by sno having count(*)>2; C: select sno from sc where grade>90 and count(*)>2 group by sno; D: select sno from sc where grade>90 group by sno having count(sno)>2;

以下运行DLL文件的语法格式不正确的是（）。 A: C:\>rundll32.exe rip.dll,Install B: C:\>rundll32.exe rip.dll,#5 C: C:\>rundll32 rip.dll,InstallService ServiceName C:\>net start ServiceName D: C:\>sc rip.dll

查询选课成绩大于90分的学生的姓名Select（）fromstudent,scwherestudent.sno=sc.snoandgrade>=90

若查询考试成绩不为空的学生的学号，下列语句哪个是正确的？（ ） A: SELECT Sno FROM SC WHERE Grade >= 0； B: SELECT Sno FROM SC WHERE Grade ！= 0； C: SELECT Sno FROM SC WHERE Grade IS NOT NULL； D: SELECT Sno FROM SC WHERE Grade NOT IS NULL；

没有选修c01课程同学的学号 SELECT<br/>sno FROM student WHERE<br/>_______________ A: cno&lt;&gt;'c01' B: cno!='c01' C: sno<br/>not in(SELECT sno FROM sc WHERE cno='c01') D: NOT<br/>EXISTS(SELECT * FROM sc WHERE cno='c01'AND student.sno=sno)

假定： A: S B: C，SC C: S，SC D: S，C，SC