sql server 撈出不重複的資料(依據某個欄位排序後找出第一筆)

select * from (SELECT *,ROW_NUMBER() OVER (PARTITION BY [不重複欄位] ORDER BY [排序欄位]) AS rn FROM [表格]) a where rn=1