select * from (
select row_number()over(partition by xx order by id desc) as num,r.*
from tableName r
) a where a.num=1
Oracle的row_number去重公式
最新推荐文章于 2024-08-21 22:10:14 发布
select * from (
select row_number()over(partition by xx order by id desc) as num,r.*
from tableName r
) a where a.num=1