/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 vote140 views1 answer
Mysql return if it contains
SQL
0 vote129 views1 answer
Sql count null as 0
SQL
0 vote144 views1 answer
Transaction and commit trong sql server
SQL
0 vote132 views2 answers
Update all columns in one update
SQL
16 votes128 views2 answers
Gremove folder from git
SQL
12 votes160 views1 answer
Create column sql server
SQL
1 vote136 views2 answers
How to check if sql query is correct online
SQL
4 votes130 views1 answer
Force drop all tables postgres
SQL
0 vote133 views1 answer
Postgres enumerated type
SQL
0 vote129 views1 answer
Sql DATE = GETDATE()
SQL