/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 vote139 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote142 views1 answer
How to insert multiple rows in mysql using laravel
SQL
15 votes129 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote139 views2 answers
Postgres show current role
SQL
17 votes162 views4 answers
Mysql remove ubuntu
SQL
1 vote147 views1 answer
Vagrant mysql downgrade version
SQL
0 vote178 views1 answer
Shortcut run sql pgadmin
SQL
1 vote134 views1 answer
Postgres set column equal to another
SQL
0 vote144 views1 answer
View psql output in horizontal scrolling
SQL
0 vote136 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL

Share