Answers for "psql get last rows"

SQL
0

postgresql get last 10 records

SELECT * from <table_name> order by "Date" DESC LIMIT 10;
Posted by: Guest on September-07-2021
0

psql get last rows

# ctid represents the physical location when you don't have an ID or a DATE
SELECT * from <table_name> ORDER BY ctid DESC LIMIT <limit>;
Posted by: Guest on October-01-2021
-1

postgres get last value

select last_value("name") over(order by created_at desc) as name from profile
Posted by: Guest on April-28-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language