/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 vote249 views1 answer
Like and not like together in sql
SQL
0 vote224 views1 answer
Oracle allow space to user
SQL
1 vote210 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote186 views1 answer
Sql comparison operators
SQL
0 vote201 views1 answer
Pl/ sql change currency
SQL
1 vote322 views1 answer
SQL server query column yes or no
SQL
0 vote199 views2 answers
Mysql decimal remove trailing zeros
SQL
1 vote204 views3 answers
Mysql connection string
SQL
0 vote214 views1 answer
How to write if case in select query in select statement
SQL
12 votes198 views4 answers
SQL Where
SQL