/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 vote210 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote207 views1 answer
Download mysql database to excel in android studio
SQL
0 vote211 views1 answer
Mysql sum per week
SQL
0 vote251 views1 answer
Sql to search who modified
SQL
1 vote156 views2 answers
Mysql type conversion
SQL
0 vote280 views1 answer
Setting default value for Boolean data type in SQL
SQL
3 votes180 views1 answer
Convert sqlite table to pandas dataframe
SQL
1 vote181 views1 answer
Where to locate set password for mysql
SQL
3 votes170 views1 answer
Sql insert inserted id
SQL
2 votes216 views1 answer
Tcl in sql
SQL

Share