/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

2 votes272 views1 answer
Mysql shell insert into
SQL
0 vote259 views1 answer
Oracle show running job
SQL
0 vote261 views1 answer
Mysql match in serialized data
SQL
0 vote244 views1 answer
Redirection 301 htaccess nom de domaine
SQL
2 votes243 views1 answer
Sqlite show table indexes
SQL
0 vote275 views2 answers
Postgresql gset
SQL
5 votes259 views1 answer
Mysql count newlines in field
SQL
0 vote255 views1 answer
Modificar tipo de dato sql server
SQL
1 vote242 views1 answer
Sql try catch
SQL
4 votes245 views2 answers
Insert current date in mysql
SQL

Share