/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

2 votes316 views1 answer
Latest record in sql
SQL
0 vote308 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
17 votes343 views6 answers
Mysql import sql file
SQL
0 vote357 views1 answer
Why we have to set the password for my sql server
SQL
32 votes370 views6 answers
How to change column name in sql
SQL
0 vote324 views1 answer
Postgresql import data from csv
SQL
0 vote424 views1 answer
Parent and child link in mysql
SQL
5 votes374 views1 answer
How to get all table names in sql query
SQL
1 vote365 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote359 views1 answer
Rename table column name in mysql
SQL