/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 vote413 views3 answers
How to reset id column in sql server
SQL
4 votes509 views6 answers
Laravel jwt
SQL
0 vote380 views1 answer
Ms sql filter all sympbol
SQL
0 vote356 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote339 views1 answer
Java mysql date format
SQL
11 votes406 views2 answers
Having clause in sql
SQL
2 votes344 views1 answer
How to add where command in update comand with joins
SQL
9 votes358 views3 answers
Show table columns mysql command line
SQL
0 vote354 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
3 votes414 views2 answers
Update part of a string in mysql
SQL

Share