请问两个关于排序的问题

Question

select employeeid,sum(freight) from orders group by employeeid 执行完后我想只显示freight最多的一列，请问怎么写？select employeeid,sum(freight) from orders group by employeeid 执行完后我想给freight排序为DESC，请问怎么写？

Answer 1

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