题目内容

检索选修四门以上课程的学生总成绩（不统计不及格的课程），并要求按总成绩的降序捧列出来。正确的 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 HAVINC COUNT()>=4 GROUP BY S ORDER BY 2 DESC
D. SELECT S，SUM(GRADE) FROM SC WHERE GRADE＞=60 ORDER BY2 DESC GROUP BY S HAVING COUNT()＞=4

查看答案

搜索结果不匹配？点我反馈

更多问题

气瓶水压试验装置的内部必须保证清洁，禁油与（）气瓶的试验装置不得混用

低压气瓶是指公称工作压力小于（）的气瓶

钢质无缝气瓶瓶体存在弧疤、焊迹或（）等热损伤而使金属受损的气瓶应报废

国际规定，电压在（）伏以下不必考虑防止电击的安全

A. 36
B. 25
C. 65