select * from (select row_number() over(partition by vjp order by id desc ) a ,e.* from COOL_TBL_CHAIN_ENVIRON e) a where a.a =1
分组取 第一条
select row_number() over(partition by “条件” order by id desc ) a ,e.* from 表名 e
得出结果
select * from (
select row_number() over(partition by “条件” order by id desc ) a ,e.* from 表名 e
) a where a.a =1