/SQL/Psql get last rows

Psql get last rows

Postgresql get last 10 records

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

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

0

Postgres get last value

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

-1

Similar codes

0 vote182 views1 answer
Postpresql relation not found
SQL
1 vote194 views1 answer
Tsql replace value in json
SQL
0 vote178 views1 answer
Sql composite key
SQL
3 votes181 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
2 votes195 views2 answers
Spring where to put the data sql
SQL
0 vote164 views1 answer
Ffeathers express mysql application users login
SQL
0 vote196 views1 answer
Learnxinyminutes sql
SQL
0 vote135 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote167 views2 answers
Sql select inside select
SQL
18 votes182 views3 answers
Mysql add column default value
SQL

Share