postgresql get last row code example

Example 1: postgresql last 12 rows

SELECT ...
LIMIT 12;

Example 2: postgres get last value

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