/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 vote171 views2 answers
Sql update multiple tables
SQL
0 vote140 views1 answer
Sql get guid
SQL
5 votes137 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote142 views1 answer
SQL: calculate hours from two dates
SQL
14 votes143 views3 answers
SQL trim
SQL
3 votes144 views2 answers
Sql select data from last week
SQL
1 vote135 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote133 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote137 views1 answer
Sql get number of days between two dates
SQL
33 votes137 views6 answers
Change column name in mysql
SQL