先按课程号升序排列,再按成绩降序排列检索出选课表中的所有信息,下面SQL语句正确的是______。
A.SELECT * FROM 选课表 ORDER BY 课程号, 成绩
B.SELECT * FROM 选课表 GROUP BY 课程号, 成绩
C.SELECT * FROM 选课表 ORDER BY 课程号, 成绩 DESC
D.SELECT * FROM 选课表 ORDER BY 课程号 DESC, 成绩
A.SELECT * FROM 选课表 ORDER BY 课程号, 成绩
B.SELECT * FROM 选课表 GROUP BY 课程号, 成绩
C.SELECT * FROM 选课表 ORDER BY 课程号, 成绩 DESC
D.SELECT * FROM 选课表 ORDER BY 课程号 DESC, 成绩
A、ORDER BY GRADE, SNO
B、ORDER BY GRADE DESC, SNO
C、ORDER BY GRADE DESC
D、ORDER BY SNO ASC, GRADE DESC
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;
A、SELECT S#,SUM(GRADE) FORM SC GROUP BY S# HAVING COUNT(*)>=4;
B、SELECT S#,SUM(GRADE) FORM SC GROUP BY S# HAVING COUNT(*)>=4 ORDER BY SUM(GRADE) DESC;
C、SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY SUM(GRADE) DESC;
D、SELECT S#,SUM(GRADE) FROM SC GROUP BY S# HAVING GRADE>=60 AND COUNT(*)>=4 ORDER BY SUM(GRADE) DESC;
A、SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC GROUP BY SNO ORDER BY SUM_GRADE DESC HAVING COUNT(*) >= 4;
B、SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC GROUP BY SNO HAVING COUNT(*)>=4 ORDER BY SUM_GRADE DESC;
C、SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC HAVING COUNT(*)>=4 GROUP BY SNO ORDER BY SUM_GRADE DESC;
D、SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC ORDER BY SUM_GRADE DESC GROUP BY SNO HAVING COUNT(*)>=4;
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!