/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 vote179 views1 answer
Order child below the parent in mysqli
SQL
0 vote155 views1 answer
Mysql server not running
SQL
0 vote159 views1 answer
Sql on-premises
SQL
0 vote174 views1 answer
Unique element in sql
SQL
5 votes149 views2 answers
Postgres update with if condition query
SQL
0 vote149 views1 answer
ORA-13717
SQL
6 votes150 views5 answers
Mysql get last insert id
SQL
6 votes155 views2 answers
Can't connect to local mysql server through socket
SQL
4 votes147 views4 answers
Print pl sql
SQL
0 vote160 views1 answer
Normalization in database
SQL

Share