/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 vote139 views2 answers
Postgres copy table from one schema to another
SQL
0 vote159 views1 answer
How convert into in in sql query
SQL
0 vote144 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote135 views1 answer
Sql gap missing values
SQL
1 vote146 views1 answer
Mysql return if it contains
SQL
25 votes141 views5 answers
Date in mysql
SQL
0 vote156 views1 answer
Sql query for login with email or username
SQL
0 vote143 views1 answer
Heidisql check how much space a row
SQL
0 vote194 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
11 votes134 views2 answers
Oracle all source
SQL

Share