sql - sql记录获取最新记录-SQL Server

Question

ID,FID,DATE_ADDED
75,67,2020-07-29 11:19:37.5230000   
76,67 ,2020-07-29 11:31:51.1870000      
77,23,2020- 07-29 11:15:44.2230000  

我有这个记录集，但是我想返回 FID 的最新条目的记录集

76,67 ,2020-07-29 11:31:51.1870000      
77,23,2020- 07-29 11:15:44.2230000  

标签： sqlsql-server

Answer 1

利用row_number()

select * from
(
select *,row_number() over(partition by fid order by date_added desc) as rn
from tablename
)A where rn=1