Question

oracle 同一个ID 有多条记录，怎么取时间最大的那一条

Answer 1

select * from (select row_number() over(partition by id order by time desc) rn, a.* from table a) where rn = 1

以闭散上兄态袜。羡激