/SQL/Select value from previous row in postgresql

Select value from previous row in postgresql

-- use LAG(column_name, lag) OVER (PARTITION BY x ORDER BY y)
select
	id,
	version,
	start_date,
	lag(dss_end_date, 1) over (partition by id order by version) as previous_row_end_date
	end_date
from
	table
order by
	id,
	version;

Similar codes

0 vote227 views2 answers
How to save result of sqlite query in a table
SQL
0 vote239 views1 answer
Create database store
SQL
1 vote226 views1 answer
Mysql show current queries
SQL
0 vote257 views1 answer
Get statis values sql
SQL
0 vote231 views1 answer
Mysql add to value
SQL
0 vote234 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
-1 vote233 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote226 views1 answer
Import local sql into remote mysql
SQL
0 vote236 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote407 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL