检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩降序排列出来，正确的SELECT语句是______。A．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 CROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)＞=4B．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY 2 DESCC．SELECT S

题目

检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩降序排列出来，正确的SELECT语句是______。

A．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 CROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)＞=4

B．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY 2 DESC

C．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY 2 DESC

D．DELECT S#,SUM(GRADＥ)FROM SC WHERE GRADE＞=60 ORDER BY 2 DESC CROUP BY S# HAVING COUNT(*)＞=4

相似考题

1.检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩的降序排列出来。正确的SELECT语句是______。A．SELECT S#, SUM(GRADE) FROM SC WHERE GRADE＞=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)＞=4B．SELECT S#, SUM(GRADE) FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY 2 DESCC．SELECT S#, SUM(GRADE) FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY 2 DESCD．SELECT S#, SUM(GRADE)FROM SC WHERE GRADE＞=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)＞=4

2.已知选课关系SC（S# char（8), C# char（8), GRADE integer)，S#学号，C#课程号，GRADE成绩。检索选修4门以上课程的学生总成绩（不统计不及格的课程），并要求按总成绩的降序排列出来。正确的SELECT语句是_________。A．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade DESCB．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY SgradeC．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESCD．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 and COUNT(*)＞=4 GROUP B

3.9、已知选课关系SC（S# char（8), C# char（8), GRADE integer)，S#学号，C#课程号，GRADE成绩。检索选修4门以上课程的学生总成绩（不统计不及格的课程），并要求按总成绩的降序排列出来。正确的SELECT语句是_________。A．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade DESCB．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY SgradeC．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESCD．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 and COUNT(*)＞=4 GROUP B

4.学生选课的关系模式为SC(SN,CN,SM)，其中SN为学号，CN为课程号，SM为成绩。检索选修3门以上课程的学生总成绩，并按总成绩的降序排列。 SELECT SN,SUM(SM) FROM SC ______0RDER BY 2 DESC;A．GROUP BY SN HAVING COUNT(*)＞=3B．HAVINGCOUNT(*)＞=3 GROUP BY SNC．GROUP BY SM HAVING COUNT(*)＞=3D．HAVING COUNT(*)＞=3 GROUP BY SM

更多“检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩降序排列出来,正确的SELE ”相关问题

  • 第1题：

    已知选课关系SC（S# char（8), C# char（8), GRADE integer)，S#学号，C#课程号，GRADE成绩。检索选修4门以上课程的学生总成绩（不统计不及格的课程），并要求按总成绩的降序排列出来。正确的SELECT语句是_____。

    A．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 and COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC

    B．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC

    C．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade

    D．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)&g


    A

  • 第2题：

    查询选修五门以上课程的总成绩（不统计0分的课程），并按总成绩的升序排列


    select sc.Sno ,AVG(sc.grade) from SC where sc.Sno in(select sc2.Sno from SC sc2where sc2.Scoregroup by sc2.Snohaving COUNT(sc2.Cno)>2)group by sc.Sno

  • 第3题：

    已知选课关系SC（S# char（8), C# char（8), GRADE integer),S#学号,C#课程号,GRADE成绩。检索选修4门以上课程的学生总成绩（不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SELECT语句是（）。

    A．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade DESC;

    B．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 and COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESC;

    C．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY Sgrade;

    D．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROU


    A

  • 第4题：

    检索选修四门以上课程的学生总成绩，并要求按总成绩的降序排列出来。正确的SELECT语句是（）。

    A．SELECT SNO, SUM (GRADE) FROM SC GROUP BY SNO ORDER BY 2 DESC HAVING COUNT(*) ＞= 4;

    B．SELECT SNO, SUM (GRADE) FROM SC GROUP BY SNO HAVING COUNT(*)＞=4 ORDER BY 2 DESC;

    C．SELECT SNO, SUM (GRADE) FROM SC HAVING COUNT(*)＞=4 GROUP BY SNO ORDER BY 2 DESC;

    D．SELECT SNO, SUM (GRADE) FROM SC ORDER BY 2 DESC GROUP BY SNO HAVING COUNT(*)＞=4;


    SELECT S# FORM SC WHERE C#=“C2” AND GRADE＞＝ALL (SELECT GRADE FORM SC WHERE C#=“C2”)

  • 第5题：

    9、已知选课关系SC（S# char（8), C# char（8), GRADE integer)，S#学号，C#课程号，GRADE成绩。检索选修4门以上课程的学生总成绩（不统计不及格的课程），并要求按总成绩的降序排列出来。正确的SELECT语句是_________。

    A．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY Sgrade DESC

    B．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY Sgrade

    C．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY Sgrade DESC

    D．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 and COUNT(*)>=4 GROUP B


    D

相关内容