/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 votes266 views1 answer
Flask sqlalchemy boolean field
SQL
1 vote177 views1 answer
Create another table from existing table sql oracle
SQL
0 vote308 views1 answer
Provera dupliranih konatakata
SQL
0 vote207 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
2 votes306 views2 answers
MySql FULL OUTER JOIN
SQL
1 vote188 views1 answer
Name of today sql
SQL
0 vote188 views1 answer
Mysql query with sql to get the next row
SQL
0 vote174 views1 answer
How to find username and password in oracle 18c
SQL
0 vote199 views1 answer
Intellij mysql set timezone
SQL
-1 vote187 views2 answers
First letter capital in mysql query
SQL

Share