/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 vote344 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote320 views1 answer
Oracle last connection
SQL
1 vote359 views1 answer
Mysql show database size in mb
SQL
0 vote356 views1 answer
Bidirectional outer join sql
SQL
10 votes309 views1 answer
Oracle view dependencies
SQL
1 vote333 views1 answer
How to run parallel queries in sql server with entity framework
SQL
1 vote338 views1 answer
Last 6 months postgresql
SQL
1 vote352 views2 answers
Sql server add time to date
SQL
1 vote345 views2 answers
Mysql trim whitespace
SQL
1 vote350 views1 answer
Use of now() in mysql
SQL

Share