(select * from (select p.*, rank() over (partition by a0100 order by i9999 desc) rk from dzkAAP p) where rk=1 ) z
Oracle表里 同个人有五条数据 ,取出id值最大的那条数据:
最新推荐文章于 2022-08-05 09:40:28 发布
(select * from (select p.*, rank() over (partition by a0100 order by i9999 desc) rk from dzkAAP p) where rk=1 ) z