/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 vote169 views1 answer
Convert .mdf to .bak
SQL
3 votes210 views2 answers
@sqlresultsetmapping
SQL
1 vote172 views1 answer
Sql padd let with zeros
SQL
0 vote183 views1 answer
Sql use with to get value counts and percentages
SQL
1 vote121 views1 answer
Postgresql last element of array
SQL
0 vote161 views1 answer
Import big data to mysql
SQL
0 vote170 views1 answer
How to create a table based on another table in mysql
SQL
0 vote172 views1 answer
Order by in codeigniter query builder
SQL
0 vote165 views1 answer
Set a value by excuting stored procedure
SQL
1 vote498 views1 answer
Mysql event last execution
SQL

Share