/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

0 vote144 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
3 votes152 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
11 votes228 views1 answer
Oracle insert from select
SQL
0 vote166 views1 answer
Truncate a table then insert data
SQL
0 vote182 views1 answer
Provera dupliranih konatakata
SQL
0 vote156 views4 answers
Mysql replace regex
SQL
1 vote140 views1 answer
Substr sql last character
SQL
0 vote151 views1 answer
Amount of entries in a table psql
SQL
0 vote159 views2 answers
Dbms interview questions
SQL
19 votes147 views2 answers
Mysql tinyint max value
SQL