/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 vote209 views1 answer
Set a default value for a column in sqlite
SQL
0 vote202 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote196 views1 answer
Teller stamp , bmo , PDF
SQL
1 vote244 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote189 views1 answer
Find usage of table in sql server
SQL
0 vote251 views2 answers
How to install psql in ubuntu
SQL
1 vote201 views1 answer
Sql update table remove spaces
SQL
17 votes200 views4 answers
Sort by mysql
SQL
1 vote183 views4 answers
Sql now
SQL
0 vote229 views1 answer
Sql sort ages
SQL

Share