m0_50105929的博客

最近在重构代码，原来的一个查询语句是这么写的。 select * from (select t.product_id, t.rate_id, t.year t.value, to_char(t.time, ‘‘yyyyMMddhh24miss’’) time, row_number() over(partition by t.product_id,t.rate_id,t.year order by t.time desc) rank from table t where t.id = :id) where