/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 vote280 views2 answers
Full join sql
SQL
11 votes310 views1 answer
Oracle view source
SQL
0 vote291 views1 answer
Postgres enumerated type
SQL
0 vote287 views1 answer
Denormalise SQL command
SQL
0 vote309 views1 answer
Wordpress database query change url
SQL
17 votes287 views4 answers
Set mysql Password
SQL
0 vote314 views4 answers
Restart MySQL
SQL
2 votes313 views1 answer
Sql string_agg
SQL
0 vote292 views2 answers
Azure sql-datenbank
SQL
0 vote293 views1 answer
Query archive mode
SQL

Share