/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 votes346 views1 answer
Sql create database
SQL
12 votes390 views6 answers
How to install sqlite3 in python
SQL
17 votes329 views5 answers
Order by sql
SQL
0 vote347 views1 answer
Postgresql delete multiple rows
SQL
1 vote348 views1 answer
Sql server get users
SQL
0 vote397 views1 answer
Sql pivot without aggregate
SQL
1 vote359 views1 answer
Md5 encryption for existing records
SQL
2 votes356 views1 answer
Get first n letter of department name in sql
SQL
1 vote350 views1 answer
Decalre temp table sql
SQL
2 votes342 views1 answer
Possgress drop if exists table
SQL

Share