/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

18 votes125 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote126 views1 answer
Insert into select with group by
SQL
2 votes122 views1 answer
Sqlite indexes
SQL
2 votes158 views3 answers
Mysql kill
SQL
4 votes112 views2 answers
Truncate oracle
SQL
4 votes132 views1 answer
T-sql get duplicate rows
SQL
0 vote127 views1 answer
Sql waitfor
SQL
14 votes121 views6 answers
Auto_increment mysql
SQL
0 vote111 views1 answer
Max length found in mysql
SQL
0 vote108 views1 answer
Transalations from sql to Linq count and group by
SQL