/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 votes86 views1 answer
Mysql admin u root p password change password
SQL
0 vote128 views3 answers
Postgresql grant alter table to user
SQL
1 vote155 views3 answers
Alter schema sql server
SQL
0 vote137 views1 answer
Guid string to binary better
SQL
0 vote151 views2 answers
Collation in sql
SQL
0 vote147 views1 answer
Select odd records sql
SQL
0 vote141 views2 answers
Sql searching via key word
SQL
0 vote129 views1 answer
Oracle sql developer closed connection
SQL
2 votes184 views2 answers
Mysql date range
SQL
0 vote128 views1 answer
Java sql insert return id
SQL

Share