/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

4 votes119 views1 answer
Id primary key auto generated
SQL
0 vote126 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote115 views1 answer
Sql last 7 days
SQL
0 vote109 views1 answer
How to drop a trigger in postgresql
SQL
0 vote110 views1 answer
Sql decode
SQL
15 votes126 views4 answers
Mysql export database command line
SQL
0 vote119 views1 answer
Code to move ietms from one table to another myswl
SQL
2 votes117 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote112 views1 answer
Truncate table sql server foreign key
SQL
0 vote65 views1 answer
Import sql file in mysql linux
SQL