Question

SQL向每个学生的总成绩，输出学号和总成绩，按总成绩排序(降序)，若总成绩相同，再按学号排序（升序)。

SQL语句怎么写 ？

Answer 1

select xuehao as 学号,score as 总成绩 from CJB
where xuehao in(select xuehao from XSB)
group by xuehao,score
order by score desc,xuehao

Answer 2

select id as 学号, sum(score) as 总成绩
from 成绩表
group by id
order by sum(score) desc, id asc