select top 10 ROW_NUMBER() OVER (ORDER BY sum(ProductNum*Integral) desc) as id, RegisterMember, sum(ProductNum*Integral) as yeji from dbo.v_OrderDetail where " + Filter + " group by RegisterMember order by sum(ProductNum*Integral) desc
使用group by 统计的排行榜时,加上一个序号
ROW_NUMBER() OVER (ORDER BY sum(ProductNum*Integral) desc) as id