sql server分组排序取出每组顺序第一条

-- sql server分组排序取出每组顺序第一条
select * from (
select *,row_number() over(partition by bloodbag_id order by operation_date desc) rn from tt_blood_log
)t where t.rn = 1