/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 vote125 views8 answers
Sql to c# linq converter online
SQL
0 vote135 views1 answer
Pl/pgsql declare variable
SQL
1 vote129 views1 answer
Tsql create unique index composite
SQL
0 vote107 views1 answer
Mysql select where text contains
SQL
0 vote113 views1 answer
Postgresql stored procedure update table values
SQL
1 vote155 views1 answer
Mysql tables max count
SQL
0 vote120 views1 answer
Power bi union columns
SQL
11 votes237 views2 answers
Import mysql dump command line windows
SQL
0 vote115 views1 answer
Python sqlalchemy orm to select null values
SQL
10 votes115 views1 answer
Query to find object dependencies in oracle
SQL

Share