/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 vote181 views5 answers
Left join sql
SQL
5 votes136 views1 answer
Commentaire table oracle
SQL
0 vote125 views1 answer
Oracle index hint
SQL
2 votes128 views1 answer
Get first n letter of department name in sql
SQL
4 votes159 views2 answers
Postgresql float data type
SQL
0 vote124 views1 answer
Object Information
SQL
1 vote120 views1 answer
Mysql batch insert
SQL
3 votes138 views1 answer
Oracle user privileges
SQL
0 vote126 views1 answer
Sql select all tables from database change url
SQL
1 vote123 views1 answer
Scaffold mysql database
SQL