sqlserver 根据排序取相同值第一个

select * from (select * from(

select row_number() over(partition by Pid order by created desc) rowId,* from

table ) t

where rowId=1) tt