select temp.*
from (SELECT *,Row_Number() OVER (partition by 分组字段 ORDER BY 排序字段 desc) as rank FROM user_task_tb where 条件) temp
where rank = 1
sqlserver分组查询,获取最新一条数据
最新推荐文章于 2024-07-25 19:14:08 发布
select temp.*
from (SELECT *,Row_Number() OVER (partition by 分组字段 ORDER BY 排序字段 desc) as rank FROM user_task_tb where 条件) temp
where rank = 1