问题描述:
[问答]
检索选修四门以上课程的学生总成绩,并要求按总成绩的降序排列出来。正确的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 SHAVING 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;
参考答案:查看无
答案解析:无
☆收藏
答案解析:无
☆收藏
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.“以0开头,以1结尾的二进制 2.以下哪些命令可以绘制矩形() 3.古菌细胞壁也含肽聚糖,但它的
