sqlserver分组查询,获取最新一条数据

    技术2022-07-11  115

    select temp.* from (SELECT *,Row_Number() OVER (partition by 分组字段 ORDER BY 排序字段 desc) as rank FROM user_task_tb where 条件) temp where rank = 1

    Processed: 0.009, SQL: 9