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
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