/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

1 vote133 views1 answer
Mysql find most common value
SQL
1 vote141 views1 answer
Increase existing date in sql oracle
SQL
0 vote139 views1 answer
Create database like
SQL
16 votes128 views3 answers
Delete row psql
SQL
8 votes135 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote128 views2 answers
Sql query inner join 3 tables
SQL
8 votes143 views1 answer
Mysql restore database
SQL
1 vote127 views1 answer
Delete row mssql
SQL
0 vote146 views1 answer
Sql remove decimal places
SQL
0 vote152 views1 answer
Como hacer un select entre fechas mysql
SQL

Share