/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 vote179 views1 answer
Codigo crear tablas sql server
SQL
1 vote175 views1 answer
Oracle sql create view
SQL
3 votes174 views3 answers
Sql last week
SQL
0 vote164 views1 answer
How to see the query of a view in mysql
SQL
0 vote180 views1 answer
Select 1 from orders
SQL
0 vote166 views1 answer
Get first monday of month sql
SQL
1 vote180 views1 answer
Mysql select and count left join
SQL
0 vote169 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote178 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
6 votes174 views6 answers
Count mysql
SQL

Share