/SQL/Postgresql get last 10 records

Postgresql get last 10 records

Postgresql get last 10 records

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

0

Postgres get last value

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

-1

Similar codes

2 votes162 views1 answer
How to select from mssql
SQL
0 vote126 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote137 views2 answers
Sql max count
SQL
2 votes134 views1 answer
Oracle list grants on procedure
SQL
0 vote116 views1 answer
Check mysql password with docker container magento 2
SQL
1 vote122 views1 answer
Psql filed name alter
SQL
49 votes198 views6 answers
Get duplicate records in sql
SQL
0 vote130 views1 answer
Oracle allow space to user
SQL
0 vote130 views1 answer
How to save data in database in mysql node
SQL
5 votes126 views1 answer
Purge undo tablespace oracle 11g
SQL

Share