/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 vote193 views1 answer
Updating database in sql
SQL
1 vote144 views2 answers
T-sql random number for each row
SQL
0 vote146 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote136 views2 answers
Sqlite unix timestamp
SQL
24 votes154 views5 answers
List mysql users
SQL
0 vote164 views1 answer
Sql_inner_join
SQL
0 vote183 views1 answer
Get enginge db mysql
SQL
0 vote139 views1 answer
Min:sec datediff mssql
SQL
0 vote160 views1 answer
Sqlite version check
SQL
0 vote152 views1 answer
Mysql get first 2 characters of string
SQL