/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

16 votes326 views2 answers
Sql vs nosql
SQL
0 vote272 views1 answer
ORA-13717
SQL
0 vote260 views1 answer
Create table sql generator
SQL
0 vote282 views2 answers
Mysql show foreign keys
SQL
0 vote273 views2 answers
Functions with parameters SQL
SQL
2 votes264 views1 answer
How to get non distinct values in sql
SQL
1 vote265 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote289 views1 answer
Hue hive UploadingTextFiletoHive
SQL
4 votes297 views3 answers
Postgres drop all tables
SQL
34 votes256 views6 answers
Sql change data type
SQL