/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 vote290 views2 answers
Drop table if exists test
SQL
4 votes286 views1 answer
Check database name postgresql
SQL
8 votes300 views2 answers
Python simple connect to mysql
SQL
0 vote284 views1 answer
MySql Modify Increment
SQL
2 votes298 views4 answers
Mysql select into new table
SQL
18 votes299 views3 answers
Find column name in database
SQL
0 vote345 views2 answers
Mysql cast to varchar
SQL
4 votes266 views2 answers
Select todays data postgres query
SQL
4 votes290 views1 answer
What are the data types in sql
SQL
0 vote295 views1 answer
Connect to ssms with python
SQL