select * from (SELECT [Id]
,[BorrowNo]
,[BorrowMan]
,[BorrowStatic]
,[FacilityId]
,[AdminId]
,[BorrowDate]
,[BackDate]
,ROW_NUMBER() over(partition by facilityid order by Id desc ) as new_index
FROM [ProvideGrant].[dbo].[BorrowManage])a where new_index = 1
ROW_NUMBER() over(partition by facilityid order by Id desc ) as new_index 本剧意义:
以facilityid 为分区,以id为排序,显示所有,如果只显示其中的第一条 则可以使用 where new_index = 1
来显示所有分区第一条的数据。