pgsql 查每个版本最新的数据

select uuid from(select *,row_number() over(partition by productid order by time_stamp desc)rn
from "automation".data)t where rn=1