/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 vote105 views1 answer
Oracle create table auto generated primary key
SQL
0 vote95 views1 answer
Get who is hired in specific month in sql
SQL
0 vote170 views1 answer
Check user sql password from command line
SQL
0 vote122 views1 answer
Flask sqlalchemy session delete
SQL
0 vote102 views1 answer
See Foreign Key
SQL
4 votes95 views2 answers
Sql server date now
SQL
1 vote98 views1 answer
Oracle rolling back transactions
SQL
0 vote107 views1 answer
Google cloud sql postgres url example
SQL
3 votes137 views6 answers
Jwt laravel
SQL
0 vote114 views1 answer
Sql order by except one row
SQL