题目内容
（请给出正确答案）
A.SELECT姓名TOP 2 FRM成绩表WttERE物理DESC
B.SELECT姓名TOP 2 FROM成绩表FOR物理DES
C.SELECT姓名TOP 2 FROM成绩表GROUP BY物理DESC
D.SELECT姓名TOP 2 FROM成绩表ORDER BY物理DESC
安装简答题APP，拍照搜题省时又省心！
更多“在成绩表中要求按“物理”降序排列，并查询前两名的学生姓名，正…”相关的问题
A、select top 3 * from 学生
B、select top 3 from 学生
C、select 3 * from 学生
D、select top 3 * 学生
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) 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;
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) 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;
为了保护您的账号安全，请在“简答题”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！
微信搜一搜
简答题
微信搜一搜
简答题
如搜索结果不匹配，请 
