组内排序

SELECT 

abcll.carid

,abcll.nextlinktime

,abcll.inserttime

,ROW_NUMBER() over (PARTITION  by abcll.carid order by abcll.nextlinktime desc ) Nextlinkrowid

,ROW_NUMBER() over (PARTITION  by abcll.carid order by abcll.inserttime desc ) insertrowid

FROM [UsedCar].[dbo].[AutonomousBuyCarLinkLog] abcll with(nolock)

where nextlinktime !=inserttime 

group by carid,inserttime,nextlinktime

​