/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

1 vote168 views1 answer
Check message id sql server
SQL
0 vote166 views1 answer
Oracle SQL join three tables and group by column
SQL
37 votes173 views3 answers
Duplicate records in sql
SQL
11 votes156 views2 answers
Having clause
SQL
0 vote165 views1 answer
Postgres drop type
SQL
0 vote171 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
7 votes193 views3 answers
Convert ansi sql
SQL
36 votes167 views6 answers
Delete from where sql
SQL
0 vote160 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
7 votes164 views1 answer
Safe update mysql
SQL

Share