/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 vote165 views3 answers
Create temp table in sql
SQL
2 votes168 views1 answer
Sql update from different table
SQL
1 vote166 views3 answers
Mysql connection string
SQL
4 votes174 views1 answer
Sql data types
SQL
2 votes180 views1 answer
Mysql time ago difference
SQL
31 votes233 views4 answers
Mysql grant execute
SQL
2 votes181 views1 answer
Guid to string sql
SQL
0 vote217 views1 answer
Postgresql remove new line from string
SQL
12 votes171 views4 answers
Mysql version query
SQL
0 vote280 views1 answer
Mysql select field if condition
SQL