select t.name1,t.name2,t.zx
from (select row_number()over(partition by name1 order by zx desc)rn, test.* from test)t
where t.rn=1;
oracle 分组查询取第一条数据 关联查询 最后一条数据
最新推荐文章于 2024-07-16 15:12:44 发布
select t.name1,t.name2,t.zx
from (select row_number()over(partition by name1 order by zx desc)rn, test.* from test)t
where t.rn=1;