/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 vote111 views1 answer
Mysql select smaller of two values
SQL
0 vote210 views1 answer
Install mysql on bash
SQL
0 vote109 views1 answer
How to remove default in mysql
SQL
6 votes146 views2 answers
Subtr Oracle ?
SQL
0 vote113 views1 answer
Ksql quickstart docker
SQL
1 vote112 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote117 views1 answer
When mysql server would not work in xampp
SQL
0 vote147 views1 answer
Copy from one table to another postgres using matching column
SQL
5 votes106 views5 answers
Find max number in sql
SQL
0 vote109 views1 answer
Version and edition of SQL Server Database Engine
SQL

Share