select *
from (select hs.*,
row_number() over(partition by hs.ratio_id order by hs.created_date desc) rn
from ratio_his hs)
where rn = 1
Oracle去重sql语句
最新推荐文章于 2023-04-25 19:23:55 发布
select *
from (select hs.*,
row_number() over(partition by hs.ratio_id order by hs.created_date desc) rn
from ratio_his hs)
where rn = 1