题目内容
（请给出正确答案）
A.ORDER BY 总评成绩 DESC,性别
B.ORDER BY 总评成绩,性别 DESC
C.ORDER BY 总评成绩 DESC,性别 DESC
D.ORDER BY 总评成绩 ASC,性别 DESC
参考答案
简答题官方参考答案
（由简答题聘请的专业题库老师提供的解答）
网友提供的答案
更多“查询结果输出时要求按“总评成绩”降序排列，相同者按“性别”升序，正确的子句是_________。”相关的问题
A. ORDER BY 工资
B. ORDER BY 工资 desc
C. ORDER BY 工资 asc
D. ORDER BY 工资 dictinct
A、select * from student order by sdept , sage
B、select sname, sdept, sage from student order by sdept , sage
C、select sname, sdept, sage from student order by sdept desc , sage
D、select * from student order by sdept desc, sage
A、select top 3 * from 学生
B、select top 3 from 学生
C、select 3 * from 学生
D、select top 3 * 学生
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、4，8
B、1，5，6，7
C、2，3，6，8
D、1，5，7
将“选课”表中的1002号课的所有成绩提高10分，正确的SQL语句是_____。
A、UPDATE 选课 SET 成绩=成绩+10 WHERE 课号=‘1002’；
B、UPDATE 选课 SET 成绩=成绩+10 WHERE 课号=1002；
C、SET 选课 UPDATE 成绩=成绩+10 WHERE 课号=‘1002’；
D、UPDATE 选课 SET 成绩+10 WHERE 课号=‘1002’；
警告：系统检测到您的账号存在安全风险
为了保护您的账号安全，请在“简答题”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！
