/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 vote242 views1 answer
Postgresql import data from csv
SQL
0 vote204 views1 answer
Sql developer connect to sql server
SQL
0 vote216 views1 answer
Oracle sql drop table
SQL
0 vote194 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote215 views1 answer
How to combine first and last nae into one columb sql
SQL
5 votes194 views1 answer
Sqlite alter table add column
SQL
0 vote262 views1 answer
Mysql sum per week
SQL
1 vote216 views2 answers
This month mysql where
SQL
0 vote205 views1 answer
Postgresql inheritance
SQL
1 vote210 views1 answer
How to see all table partition in oracle
SQL