/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 vote281 views1 answer
Get the next column of a table in mysql
SQL
0 vote270 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
1 vote219 views1 answer
Postgres grant read only access to database
SQL
0 vote273 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote257 views1 answer
Mysql replication change database name
SQL
0 vote275 views1 answer
Oracle sql alter view add column
SQL
0 vote267 views1 answer
Sql server query database space available
SQL
5 votes246 views3 answers
Truncate function in sql oracle
SQL
5 votes283 views2 answers
Mysql create database charset utf8mb4
SQL
-1 vote254 views1 answer
Export mysql table to file
SQL

Share