query to get last record from table in sql postgresql code example

Example: postgres get last value

select last_value("name") over(order by created_at desc) as name from profile