/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

3 votes135 views1 answer
Sql timestamp to date
SQL
46 votes224 views4 answers
Create column sql
SQL
0 vote163 views1 answer
Sql server convert to guid
SQL
0 vote139 views1 answer
Mysql sql select one day before
SQL
2 votes137 views1 answer
Oracle create directory
SQL
1 vote220 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote142 views2 answers
Mysql two column combination unique
SQL
0 vote160 views1 answer
Mysql grouping functions
SQL
1 vote163 views1 answer
Add current timestamp in mysql
SQL
0 vote176 views1 answer
Insert value in identity
SQL