/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 vote339 views1 answer
Md5 encryption for existing records
SQL
16 votes347 views1 answer
Mysql reset auto increment value
SQL
58 votes636 views6 answers
Create new user in postgres
SQL
1 vote297 views2 answers
Into sql
SQL
0 vote334 views2 answers
PostgreSQL having
SQL
2 votes341 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote319 views1 answer
Where in clause tsql
SQL
6 votes345 views1 answer
Postgres get size of database
SQL
0 vote321 views1 answer
Postgresql conectar
SQL
0 vote329 views1 answer
Create or replace view postgress
SQL