/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

1 vote200 views1 answer
Mysql show queries running
SQL
4 votes193 views1 answer
Oracle error compilation line
SQL
0 vote203 views1 answer
Intellij idea add mysql connector
SQL
0 vote199 views1 answer
Influxdb clone measurement
SQL
0 vote207 views1 answer
Oracle sql add column auto generated value
SQL
0 vote255 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote217 views1 answer
Sql query inline if
SQL
-1 vote286 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote221 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
1 vote196 views1 answer
Sql trigger before delete
SQL

Share