/SQL/Postgresql get last 10 records

Postgresql get last 10 records

Postgresql get last 10 records

SELECT * from <table_name> order by "Date" DESC LIMIT 10;

0

Postgres get last value

select last_value("name") over(order by created_at desc) as name from profile

-1

Similar codes

1 vote114 views1 answer
Trim leading zeros in sql
SQL
0 vote100 views1 answer
Sum value by month sql
SQL
7 votes119 views2 answers
Where keyword sql
SQL
0 vote105 views1 answer
Selects all the columns from the sailors table
SQL
0 vote120 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
1 vote100 views1 answer
Oracle add proxy
SQL
1 vote100 views1 answer
Oracle db create new schema
SQL
0 vote115 views1 answer
Laravel migration sql dump
SQL
0 vote102 views1 answer
Sql change default collation to utf8
SQL
27 votes223 views3 answers
Mysql delete row
SQL

Share