1.比如sum(score)在第1列,那么你可以这样排序。 select sum(score) from t order by 1;--此处的1代表sum(score)所在的列为第一列 2.给sum(sorce)列取个别名。 select sum(score) sum_sorce from t order by sum_sorce;
我晕 我忘记order by了没想起来谢谢了~
select scoretable.sc from (select sum(score) sc from t_score group by sno) scoretable order by desc;
select sum(score) from t order by 1;--此处的1代表sum(score)所在的列为第一列
2.给sum(sorce)列取个别名。
select sum(score) sum_sorce from t order by sum_sorce;