/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

1 vote139 views2 answers
Sql groub by count
SQL
1 vote134 views3 answers
Sql server get week dates from week number
SQL
1 vote160 views1 answer
Mysql dump specific tables
SQL
0 vote128 views1 answer
Metada in sql
SQL
2 votes131 views1 answer
Ssh mysql port forwarding
SQL
0 vote137 views1 answer
Load utilities in sql server
SQL
1 vote153 views2 answers
Check if word is in column sql
SQL
0 vote193 views1 answer
Sql server is not
SQL
0 vote147 views1 answer
Select * from mysql.proc
SQL
0 vote144 views1 answer
Oracle string substitution
SQL