/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

1 vote334 views1 answer
Store select query result in variable sql server
SQL
0 vote320 views1 answer
How to connect pgadmin with excel
SQL
15 votes328 views4 answers
Export mysql db using command line
SQL
1 vote310 views2 answers
Select only columns that are not empty oracle sql
SQL
23 votes311 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote323 views1 answer
Get null value in sql
SQL
0 vote326 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote313 views1 answer
Get from database the most recent data limit by 5
SQL
8 votes307 views2 answers
Mysql query dates between two dates
SQL
-2 votes308 views1 answer
Modify column name in tsql
SQL