select * from
( SELECT ROW_NUMBER() over(partition by [项目编号] order by [金额] desc) as rowNum
,*
FROM [dbo].[#a] ) temp
where temp.rowNum <= 10
partition :按照项目编号分组。
然后按照金额排序。
select * from
( SELECT ROW_NUMBER() over(partition by [项目编号] order by [金额] desc) as rowNum
,*
FROM [dbo].[#a] ) temp
where temp.rowNum <= 10
partition :按照项目编号分组。
然后按照金额排序。