/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 vote188 views1 answer
Mssql dockere
SQL
1 vote191 views1 answer
Mysql get max value and id
SQL
0 vote179 views1 answer
Mysql count with two joins
SQL
0 vote203 views1 answer
Mysql join only one column
SQL
0 vote163 views1 answer
Get only first row mysql
SQL
0 vote176 views1 answer
Sql get month from date
SQL
1 vote199 views1 answer
Postgresql round double precision
SQL
1 vote147 views1 answer
Psql kill pid
SQL
1 vote201 views1 answer
Postgres count string length
SQL
0 vote177 views1 answer
Sql replace id with name from another table
SQL