/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 vote242 views0 answer
SQL
-2 votes264 views1 answer
Modify column name in tsql
SQL
15 votes279 views1 answer
Mysql int range
SQL
1 vote265 views1 answer
Select inside insert query
SQL
0 vote288 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote273 views1 answer
Sql select max value for each group
SQL
6 votes311 views6 answers
Rename column postgres
SQL
16 votes287 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote291 views1 answer
Show tables in cassandra cql
SQL
2 votes256 views1 answer
Docker run postgres locally
SQL

Share