/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 votes174 views1 answer
Ssh mysql port forwarding
SQL
0 vote226 views1 answer
Mysl like insert a variable
SQL
1 vote186 views1 answer
Hackerrank sql test solutions
SQL
1 vote191 views2 answers
How to combine 2 tables in MySQL
SQL
13 votes174 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
11 votes179 views5 answers
Update table from another table mysql
SQL
1 vote184 views1 answer
Mysql select row max date
SQL
0 vote171 views1 answer
Sql query for getting data with join and count
SQL
1 vote158 views1 answer
Funzioni plsql
SQL
-1 vote161 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL