/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 vote197 views1 answer
Type int in mysql maxlenght
SQL
0 vote238 views1 answer
Mariadb change column type
SQL
0 vote190 views1 answer
Database traccar
SQL
0 vote195 views1 answer
Implicit inner join table alias with id values
SQL
3 votes183 views2 answers
Sql paging query
SQL
0 vote211 views4 answers
Forenkey code alchemy sql
SQL
0 vote265 views2 answers
Fanyi
SQL
3 votes204 views2 answers
Oracle apex view logs
SQL
11 votes199 views2 answers
Safe mode off mysql
SQL
0 vote188 views1 answer
How to set sql_mode for a query in CI model
SQL

Share