/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 vote309 views1 answer
Sql query inline if
SQL
-1 vote305 views1 answer
Pl/sql how to delete a trigger
SQL
2 votes267 views1 answer
Oracle drop table free up space
SQL
1 vote218 views1 answer
Oracle compile schema
SQL
1 vote269 views1 answer
Oracle add proxy
SQL
0 vote290 views1 answer
Closure in sql
SQL
0 vote284 views1 answer
Get date from timestamp in mysql
SQL
0 vote363 views1 answer
Restart serial number for postgres
SQL
-1 vote262 views3 answers
Check table exist postgresql
SQL
0 vote274 views1 answer
Sql server concat null
SQL