/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

0 vote235 views1 answer
Get initials name in sql
SQL
1 vote235 views1 answer
Check current sequence value postgres
SQL
0 vote207 views1 answer
Add plugins to mysql workbench
SQL
-1 vote209 views1 answer
Mysql delete duplicate rows except one
SQL
35 votes221 views6 answers
Postgres
SQL
17 votes255 views2 answers
T_sql contains
SQL
2 votes223 views1 answer
Sqlplus clear screen
SQL
2 votes208 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote219 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote242 views1 answer
Check constraint is violated
SQL

Share