/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

16 votes209 views1 answer
Mysql reset auto increment value
SQL
0 vote188 views1 answer
Replace sqlalchemy
SQL
8 votes188 views3 answers
Postgresql connection string c#
SQL
15 votes201 views2 answers
Select Options
SQL
1 vote215 views1 answer
Default
SQL
0 vote193 views1 answer
Select in select sql
SQL
0 vote205 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
3 votes190 views2 answers
Postgres alter table owner
SQL
1 vote199 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote199 views1 answer
Mysql filter based on datediff
SQL