SQL 获取多个分组中的N个最新行
示例
给定此数据
;with CTE as (SELECT *, ROW_NUMBER() OVER (PARTITION BY User_ID ORDER BY Completion_Date DESC) Row_Num FROM Data) SELECT * FORM CTE WHERE Row_Num <= n
使用n=1,您将获得每个最近的一行user_id:
给定此数据
;with CTE as (SELECT *, ROW_NUMBER() OVER (PARTITION BY User_ID ORDER BY Completion_Date DESC) Row_Num FROM Data) SELECT * FORM CTE WHERE Row_Num <= n
使用n=1,您将获得每个最近的一行user_id: