请问两个关于排序的问题

[qq68435700]

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

select employeeid,sum(freight) from orders group by employeeid 执行完后我想给freight排序为DESC，请问怎么写？

[nolast02]

楼上正解

• 打赏
• 举报

回复 赞

[narsh]

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

• 打赏
• 举报

回复 赞