/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

-2 votes264 views1 answer
Use of where in left join in mysql
SQL
2 votes289 views1 answer
Rails execute sql
SQL
0 vote282 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
1 vote257 views1 answer
Select from one table where not on the other
SQL
1 vote267 views1 answer
Woocommerce mysql price table
SQL
0 vote287 views2 answers
Postgresql variable in query
SQL
0 vote257 views1 answer
Call function sql oracle
SQL
0 vote299 views1 answer
Fetching data from mysqldb
SQL
0 vote275 views1 answer
Convert rows to columns in sql server
SQL
0 vote225 views1 answer
Bigquery information_schema schema all columns
SQL