数据按某个字段分组，且取每个分组的最大值

select 
push_id AS pushId,
device_id AS deviceId,
"timestamp" AS statusTime,
status_type AS statusType 
from (
select ROW_NUMBER() over(partition by status_type order by "timestamp" desc nulls last) RowNum
  ,pamip_status.*
  from pamip_status where push_id ='57c792ad67dc4ec3612da00c' )t where rownum =1