/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

4 votes284 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
2 votes282 views1 answer
Convert series number to date in sql
SQL
0 vote318 views1 answer
Connecting mySQL to STS
SQL
1 vote341 views2 answers
Full join
SQL
0 vote304 views1 answer
Sql server select furst day of current year
SQL
12 votes291 views2 answers
Delete all data in neo4j
SQL
0 vote315 views1 answer
Sql last time database was accessed
SQL
0 vote403 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote333 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote339 views1 answer
Sqlite trim
SQL

Share