psql get last rows

RicHincapie answered on April 28, 2021 Popularity 9/10 Helpfulness 4/10

answer psql get last rows

Comment

# 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>;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: get psql rows sql

Link to this answer
Share Copy Link

Contributed on Oct 01 2021

RicHincapie

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

SELECT * from <table_name> order by "Date" DESC LIMIT 10;

Popularity 9/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: get

Link to this answer
Share Copy Link

Contributed on Sep 07 2021

Wide-eyed Wombat

0 Answers Avg Quality 2/10

Comment

-1

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

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: get

Link to this answer
Share Copy Link

Contributed on Apr 28 2021

Restu Wahyu Saputra

0 Answers Avg Quality 2/10