【单选题】
检索选修四门以上课程的学生总成绩,并要求按总成绩的降序排列出来。正确的SELECT语句是( )。
①
SELECTSNO, SUM (GRADE) FROM SC GROUP BYSNO ORDER BY2 DESC HAVING COUNT(*) >= 4;
②
SELECTSNO, SUM (GRADE) FROM SC GROUP BYSNO HAVING COUNT(*)>=4 ORDER BY2 DESC;
③
SELECTSNO, SUM (GRADE) FROM SC HAVING COUNT(*)>=4 GROUP BYSNO ORDER BY2 DESC;
④
SELECTSNO, SUM (GRADE) FROM SC ORDER BY2 DESC GROUP BYSNO HAVING COUNT(*)>=4;
【单选题】
检索选修四门以上课程的学生总成绩,并要求按总成绩的降序排列出来。正确的SELECT语句是( )。
①
A.SELECTSNO, SUM (GRADE) FROM SC GROUP BYSNO ORDER BY2 DESC HAVING COUNT(*)
②
B.SELECTSNO, SUM (GRADE) FROM SC GROUP BYSNO HAVING COUNT(*)=4 ORDER BY2 DESC;
③
C.SELECTSNO, SUM (GRADE) FROM SC HAVING COUNT(*)=4 GROUP BYSNO ORDER BY2 DESC;
④
D.SELECTSNO, SUM (GRADE) FROM SC ORDER BY2 DESC GROUP BYSNO HAVING COUNT(*)