/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 vote305 views1 answer
Sql select maximum column with other columns returned
SQL
15 votes379 views4 answers
Create table if not exists sql
SQL
0 vote372 views1 answer
How to install sql in anaconda
SQL
2 votes355 views2 answers
Mysql add hours to time field
SQL
0 vote373 views1 answer
Delete a temporary table mysql
SQL
0 vote372 views1 answer
Time data type in mysql
SQL
1 vote323 views1 answer
Not exists mysql
SQL
1 vote339 views2 answers
Install mysqldump ubuntu
SQL
3 votes444 views1 answer
Sql select second max
SQL
0 vote358 views1 answer
Min mysql
SQL