T-sql语句,group by 加 order by的使用方法

select AuHousesID,sum(Turnover) from Auction group by AuHousesID order by sum(Turnover) desc