/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

25 votes115 views1 answer
Mysql grant all privileges to a user
SQL
1 vote122 views1 answer
How to install mysql 8.0 windows service
SQL
19 votes127 views6 answers
What is mySQL
SQL
1 vote139 views1 answer
Mysql curdate between two dates
SQL
14 votes125 views1 answer
Excel
SQL
0 vote112 views1 answer
List MySQL Table and Index Size
SQL
5 votes135 views2 answers
To date oracle
SQL
6 votes131 views2 answers
Drop foreign key
SQL
0 vote120 views1 answer
How to make case insensitive in sql
SQL
12 votes120 views2 answers
Select into insert sql server
SQL