/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

4 votes231 views1 answer
Describe table mysql
SQL
1 vote232 views1 answer
Postgresql escape single quote
SQL
0 vote233 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote227 views1 answer
Mysql multiple group by
SQL
0 vote217 views1 answer
Time mysql w3
SQL
0 vote256 views1 answer
Mysql relationships between tables
SQL
7 votes233 views3 answers
Python and mysql connectivity
SQL
15 votes219 views2 answers
Open postgress in terminal mac
SQL
27 votes241 views5 answers
Mysql set password for user
SQL
0 vote242 views1 answer
Uncheck constraints and delete from table
SQL

Share