/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 vote344 views1 answer
Shows all databases created by user in ms sql
SQL
-1 vote346 views3 answers
My sql alter table
SQL
2 votes323 views1 answer
Sql update alias
SQL
2 votes327 views2 answers
Sql first character
SQL
0 vote314 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote340 views1 answer
T sql dynamic top n query
SQL
0 vote324 views1 answer
Mysql preg replace
SQL
1 vote263 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote337 views1 answer
Oracle table free space
SQL
13 votes380 views3 answers
Mysqldump structure only
SQL