select *
from (select t.*,
row_number() over(partition by t.fd_wupinbianhao order by t.fd_tianjiashijian desc) rn
from ekp_map_BGYPaddORdel_dt1 t) c
where rn = 1
oracle :一个表的一个id有多个记录,查询id的最新记录
最新推荐文章于 2024-07-16 15:12:44 发布
select *
from (select t.*,
row_number() over(partition by t.fd_wupinbianhao order by t.fd_tianjiashijian desc) rn
from ekp_map_BGYPaddORdel_dt1 t) c
where rn = 1