PRESTO SQL: How to get max date from multiple records?

Question

I'm trying to get the records with the max date also converted from unix time...thanks:

Answer 1

I think you want:

select t.*, from_unixtime(unix_time) as converted_time
from (select t.*, row_number() over (partition by item_id order by unix_time desc) as seqnum 
      from t
     ) t
where seqnum = 1;