/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

2 votes102 views1 answer
Get first n letter of department name in sql
SQL
0 vote105 views2 answers
Sql server Insert Into table
SQL
1 vote98 views1 answer
Deleting database in sql
SQL
0 vote111 views1 answer
Normalization in database
SQL
0 vote88 views1 answer
Postgresql conectar
SQL
-2 votes109 views1 answer
Mysql see users and passwords
SQL
0 vote101 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote101 views1 answer
Postgresql create table many-to-many
SQL
2 votes129 views1 answer
Mysql now format
SQL
0 vote99 views1 answer
Select a row include list of array with join table SQL
SQL

Share