/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

1 vote153 views1 answer
Mysql copy table1 to table2
SQL
0 vote161 views1 answer
Mysql backup certain tables workbench
SQL
1 vote164 views1 answer
Mysql drop key
SQL
1 vote160 views1 answer
Sql server cast date dd/mm/yyyy
SQL
21 votes179 views3 answers
Sql server search column name in all tables
SQL
5 votes166 views3 answers
Mysql update field from one table to another
SQL
0 vote111 views1 answer
Kannst du deine finger trainieren
SQL
0 vote157 views1 answer
Split string by comma in sql server
SQL
0 vote155 views1 answer
Mysql count unique in group statement
SQL
0 vote147 views1 answer
Restart sql server command line linux
SQL

Share