/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 vote187 views1 answer
Sqldf change user
SQL
0 vote206 views1 answer
Running mysql from bash sc
SQL
0 vote179 views1 answer
Sql compound operators
SQL
1 vote220 views2 answers
Mysql extract number from string
SQL
0 vote210 views1 answer
Insert value in identity
SQL
3 votes186 views1 answer
Show index table
SQL
0 vote206 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote196 views1 answer
ORACLE PARSE STRING
SQL
14 votes216 views1 answer
Oracle alter table add column not null
SQL
0 vote208 views1 answer
Sql injection payload list github
SQL

Share