postgresql last value code example Example: postgres get last value select last_value("name") over(order by created_at desc) as name from profile