select employeeid,sum(freight) from orders group by employeeid 执行完后我想只显示freight最多的一列,请问怎么写?
select employeeid,sum(freight) from orders group by employeeid 执行完后我想给freight排序为DESC,请问怎么写?
...全文
852打赏收藏
请问两个关于排序的问题
select employeeid,sum(freight) from orders group by employeeid 执行完后我想只显示freight最多的一列,请问怎么写? select employeeid,sum(freight) from orders group by employeeid 执行完后我想给freight排序为DESC,请问怎么写?
1:
select top 1 employeeid,sum(freight)
from orders
group by employeeid
order by sum(freight) desc
2:
select employeeid,sum(freight)
from orders
group by employeeid
order by freight DESC