/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

2 votes155 views2 answers
Postgres select duplicate columns
SQL
0 vote187 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote204 views1 answer
Month mysql
SQL
5 votes164 views2 answers
Oracle rename table
SQL
0 vote159 views1 answer
Drop CHECK constraint sql
SQL
0 vote174 views1 answer
Sql server beginning of month
SQL
5 votes170 views3 answers
String concatenation sql server
SQL
2 votes168 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote153 views1 answer
Sql server remove enter from string
SQL
4 votes164 views1 answer
SQL find text in SP
SQL