/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 vote291 views1 answer
Mysql check table exists
SQL
4 votes287 views3 answers
Mysql update with join
SQL
0 vote286 views2 answers
Sql query for getting details by id
SQL
0 vote292 views1 answer
How to alter length character varying postgres
SQL
0 vote289 views1 answer
Synapse sql table set pk
SQL
0 vote266 views1 answer
Separator mysql
SQL
0 vote288 views1 answer
Drop specific row postgresql
SQL
3 votes314 views5 answers
Sql select
SQL
13 votes318 views4 answers
Mysql remove foreign key constraint
SQL
0 vote238 views1 answer
Mysqli or pdo
SQL

Share