![](https://lstatic.shangxueba.com/jiandati/pc/images/pc_jdt_tittleico.png)
检索选修4门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SEL
检索选修4门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SELECT语句是
![](https://lstatic.shangxueba.com/jiandati/pc/images/jdt_panel_vip.png)
检索选修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 GROUP BY S# ORDER BY Sgrade DESC;
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(*)>=4 ORDER BY Sgrade DESC
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 BY S# ORDER BY Sgrade DESC
已知选课关系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 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 and COUNT(*)>=4 GROUP BY S# ORDER BY Sgrade DESC D.SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY Sgrade DESC
检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SELECT语句是______。
A.SELECT S#, SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP 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.SELECT S#, SUM(GRADE)FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)>=4
A、SELECT S#,SUM(GRAGE) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY S# 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 2 group by s# order> D、SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2
示专业列,过滤掉重复行。 2 )统计有学生选修的课程门数。 3 )求选修 C004 课程的学生的平均年龄。 4 )求学分为 3 的每门课程的学生平均成绩。 5 )统计每门课程的学生选修人数,超过 3 人的课程才统计。要求输出课程号和选修人数,查询结果按人数降序排列,若人数相同,按课程号升序排列。 6 )检索姓王的学生的姓名和年龄。 7 )在选课表中检索成绩为空值的学生学号和课程号。 8 )查询没有学生选修的课的课程号和课程名。 9 )求年龄大于女同学平均年龄的男学生姓名和年龄。 10 )求年龄大于所有女同学年龄的男学生姓名和年龄。 11 )查询所有与王华同年级、同专业,但比王华年龄大的学生的姓名、年龄和性别。 12 )检索选修课程 C002 的学生中成绩最高的学生的学号。 13 )检索学生姓名及其所选修课程的课程号和成绩。 14 )检索选修 4 门以上课程的学生总成绩 ()
A、SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP 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、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(*)>=3
B.HAVINGCOUNT(*)>=3 GROUP BY SN
C.GROUP BY SM HAVING COUNT(*)>=3
D.HAVING COUNT(*)>=3 GROUP BY SM
检索选修四门以上课程的学生总成绩,并要求按总成绩的降序排列出来。正确的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;
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!