/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 vote177 views1 answer
Time data type in mysql
SQL
0 vote144 views1 answer
Split string by comma in sql server
SQL
7 votes176 views4 answers
Mysql delete older duplicates
SQL
27 votes146 views5 answers
Add column in table
SQL
0 vote148 views2 answers
Postgresql gset
SQL
0 vote164 views1 answer
Renommer base sql
SQL
0 vote169 views1 answer
Select new table sql
SQL
2 votes296 views5 answers
Unique in sql server
SQL
0 vote142 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
2 votes150 views2 answers
Sql percentage
SQL

Share