/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 vote184 views1 answer
Sql myisam vs innodb
SQL
3 votes207 views1 answer
Sql is not like
SQL
3 votes189 views1 answer
Pl sql check if variable is empty
SQL
10 votes213 views1 answer
Oracle view dependencies
SQL
1 vote216 views4 answers
Alter schema sql
SQL
17 votes208 views5 answers
Order by sql
SQL
3 votes191 views1 answer
Select without null values sql
SQL
0 vote201 views1 answer
How to check which sp is running in sql server
SQL
0 vote198 views1 answer
SQL Server format datetime
SQL
0 vote227 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL

Share