Get last record of a table in Postgres code example

Example: postgres get last value

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