网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩降序排列出来，正确的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
参考答案
更多 “ 检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩降序排列出来，正确的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#,SUM(GRADE)FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY 2 DESCD．DELECT S#,SUM(GRADＥ)FROM SC WHERE GRADE＞=60 ORDER BY 2 DESC CROUP BY S# HAVING COUNT(*)＞=4 ” 相关考题
考题
检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩的降序排列出来。正确的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
考题
学生选课的关系模式为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
考题
已知选课关系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
考题
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
考题
已知选课关系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 DESCB．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY Sgrade DESCC．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY SgradeD．SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)g
考题
检索选修四门以上课程的学生总成绩，并要求按总成绩的降序排列出来。正确的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;
考题
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
考题
已知选课关系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
热门标签
最新试卷