/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 vote212 views1 answer
Oracle enable chain
SQL
0 vote220 views1 answer
Update sql sintax
SQL
0 vote179 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote173 views1 answer
Find largest table in mysql database
SQL
0 vote184 views1 answer
T sql cursor tr
SQL
0 vote189 views1 answer
Comparing with today and yesterday record in sql query
SQL
13 votes183 views6 answers
Current date sql
SQL
0 vote193 views1 answer
Apt install sql server
SQL
0 vote174 views1 answer
Truncate table sql server foreign key
SQL
1 vote178 views1 answer
How refresh navicat tables to see new tables
SQL

Share