/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 vote328 views1 answer
Sql character index
SQL
1 vote343 views1 answer
Sql current timestamp
SQL
0 vote321 views2 answers
Plan d'exécution requete oracle autotracer
SQL
3 votes344 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
1 vote329 views1 answer
Postgres check for foreign key
SQL
2 votes335 views3 answers
Sql interview query questions
SQL
1 vote368 views1 answer
Floor function in sql oracle
SQL
6 votes315 views2 answers
Mysql set primary key
SQL
0 vote362 views2 answers
Postgres isnull
SQL
0 vote332 views1 answer
Sql stored procedure update if parameter is not null
SQL

Share