/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

11 votes162 views1 answer
Sql insert multiple rows from select
SQL
0 vote185 views1 answer
Oracle date summer time
SQL
94 votes298 views4 answers
Create database postgres
SQL
18 votes185 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote197 views1 answer
Mysql wsrep ls
SQL
4 votes145 views1 answer
Postgresql show current database
SQL
5 votes148 views1 answer
How to check nls timestamp format in oracle
SQL
1 vote166 views1 answer
Mysql return if it contains
SQL
1 vote167 views1 answer
Mysql connect bash
SQL
0 vote172 views1 answer
Mysql concatenate select results
SQL

Share