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相同字段有多条记录,取时间最近的一条
最新推荐文章于 2024-07-16 15:12:44 发布
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