SELECT top 10 [employerid] from
( select distinct([employerid]),[deal_amount] from [TradeDatabase].[dbo].[t_deal_record] ) as tabless order by [deal_amount] desc
转载于:https://www.cnblogs.com/zhanglee/archive/2011/12/27/2731573.html