select * from (
select tmp.*, row_number() over(PARTITION BY 分组字段 order by 排序字段 desc) as rn from tablename tmp
) where rn = 1
转载于:https://my.oschina.net/u/1766298/blog/1036551
select * from (
select tmp.*, row_number() over(PARTITION BY 分组字段 order by 排序字段 desc) as rn from tablename tmp
) where rn = 1
转载于:https://my.oschina.net/u/1766298/blog/1036551