/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 votes169 views1 answer
Insert from table tsql
SQL
17 votes171 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote141 views1 answer
Delete record by id sql
SQL
0 vote132 views1 answer
Mysql concat and use as where column
SQL
1 vote146 views1 answer
Raise application error in oracle
SQL
0 vote137 views1 answer
Suse start MySQL
SQL
0 vote120 views2 answers
Android sqlite query join
SQL
20 votes144 views3 answers
Update values in select statement sql
SQL
0 vote119 views1 answer
Login phpmyadmin without password
SQL
0 vote132 views2 answers
Android sqlite tutorial for beginners
SQL

Share