/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

2 votes137 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote176 views2 answers
Nested query
SQL
0 vote104 views4 answers
Sql limit 1 offset 1
SQL
0 vote171 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote152 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote156 views1 answer
Sql stored procedure update if parameter is not null
SQL
13 votes184 views3 answers
Sql select from multiple tables without join
SQL
5 votes183 views2 answers
Functions
SQL
11 votes155 views1 answer
Creating tables in sql with python
SQL
16 votes155 views3 answers
Update table from another table
SQL

Share