/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

0 vote122 views1 answer
Like sql for second letter of the family name
SQL
4 votes120 views1 answer
Mysql insert from local csv
SQL
2 votes124 views1 answer
Date_format for time sql
SQL
0 vote189 views1 answer
How to add auto increment primary key
SQL
2 votes136 views1 answer
Postgresql create table as select
SQL
0 vote131 views1 answer
Psql list view rules
SQL
0 vote121 views1 answer
Sql sum if
SQL
2 votes138 views2 answers
Postgres add column integer
SQL
0 vote141 views1 answer
Tsql pad left
SQL
0 vote124 views2 answers
Plsql regex match whole word
SQL

Share