select * from
(select * ,row_number() over(partition by 分组1,分组2 order by 排序条件desc) as rowid from table1) as V
where rowid =1
多条件分组 取第一条
最新推荐文章于 2024-05-13 16:09:50 发布
select * from
(select * ,row_number() over(partition by 分组1,分组2 order by 排序条件desc) as rowid from table1) as V
where rowid =1