/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

18 votes216 views2 answers
Sql comments
SQL
0 vote244 views1 answer
Check database restore status sql script
SQL
0 vote204 views1 answer
Mysql change timestamp on update
SQL
11 votes192 views5 answers
How to install sqlite3 python
SQL
3 votes216 views3 answers
Update con select postgresql
SQL
1 vote264 views1 answer
Top 10 rows in mysql
SQL
0 vote198 views1 answer
SQL: calculate hours from two dates
SQL
9 votes237 views1 answer
No sql
SQL
3 votes201 views1 answer
Sql multi column index performance
SQL
1 vote189 views1 answer
Apex ORA-20999
SQL