/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

28 votes278 views4 answers
Show tables mysql
SQL
4 votes288 views1 answer
Mysql query first character
SQL
0 vote272 views1 answer
Can we rollback data that are deleted using DELETE
SQL
1 vote287 views1 answer
Pl sql insert into table
SQL
6 votes303 views3 answers
How to delete table sqlite
SQL
0 vote302 views1 answer
Postgresql stored procedure update table values
SQL
1 vote286 views1 answer
Mysql current time
SQL
0 vote263 views1 answer
Raiserror nowait sql server
SQL
0 vote254 views1 answer
Mysql percentage of total
SQL
2 votes268 views2 answers
How to get capital letter first in sql
SQL

Share