/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 vote177 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote161 views1 answer
The local psql command could not be located
SQL
1 vote2.7K views1 answer
Dropping a constraint in ms sql
SQL
3 votes174 views2 answers
Sql select data from last week
SQL
0 vote252 views1 answer
Postgresql powershell query
SQL
21 votes181 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote169 views1 answer
Grant privileges of databse to user
SQL
51 votes276 views6 answers
Change column name sql
SQL
0 vote208 views1 answer
Como hacer un select entre fechas mysql
SQL
37 votes383 views3 answers
Sql check duplicate value in column
SQL