/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 votes396 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote375 views1 answer
Sql int vs integer
SQL
2 votes337 views1 answer
Tsql copy table
SQL
0 vote334 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
7 votes364 views1 answer
Mysql remote connection command line
SQL
0 vote309 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote329 views1 answer
Mysql date minus 1 day
SQL
3 votes312 views1 answer
How to check schema privileges in oracle
SQL
0 vote332 views1 answer
Rename view mysql
SQL
0 vote317 views1 answer
SQL isnumeric DB2
SQL

Share