sql去掉重复数据在取前几条数据

SELECT  top 10 [employerid] from
     ( select distinct([employerid]),[deal_amount] from [TradeDatabase].[dbo].[t_deal_record] ) as tabless order by [deal_amount] desc

Top 10 取前面10条数据 、红部分去掉重复数据、 as  Newtable临时表、根据 deal_amount 排序
posted @ 2011-12-27 19:06  Lee zhang  阅读(357)  评论(0编辑  收藏  举报