/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

13 votes314 views6 answers
Restart postgresql
SQL
18 votes314 views6 answers
Create table mysql
SQL
1 vote366 views1 answer
Oracle select first row order by
SQL
28 votes313 views4 answers
Show tables mysql
SQL
0 vote346 views1 answer
Mysql dump with table query
SQL
0 vote319 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote331 views1 answer
Pgsql is not permitted to log in
SQL
2 votes336 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote353 views1 answer
Space not removing from column in sql
SQL
0 vote307 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL

Share