/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

3 votes136 views1 answer
Oracle undo tablespace schema
SQL
1 vote77 views1 answer
Metada in sql
SQL
0 vote84 views1 answer
Print sum of values sql
SQL
5 votes213 views2 answers
Mysql date greater than 30 days
SQL
3 votes113 views2 answers
Postgres download
SQL
5 votes136 views2 answers
To date oracle
SQL
0 vote125 views1 answer
Get foreign table names mysql
SQL
0 vote132 views1 answer
Joins vs includes
SQL
0 vote123 views1 answer
Check psql validity function
SQL
0 vote121 views2 answers
Azure sql-datenbank
SQL

Share