/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

6 votes380 views2 answers
Oracle compile trigger
SQL
-1 vote349 views1 answer
Add 10 to all numbers in a column sql
SQL
5 votes331 views6 answers
In operator sql
SQL
0 vote334 views1 answer
Sql set data from a select query to a temp table and insert
SQL
5 votes356 views1 answer
Oracle source query
SQL
1 vote317 views1 answer
Apex ORA-20999
SQL
9 votes330 views2 answers
SELECT User,Host FROM mysql.user;
SQL
10 votes306 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote347 views1 answer
Mysql backup query
SQL
3 votes293 views1 answer
V$session not found in oracle
SQL

Share