/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 vote228 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote231 views1 answer
Mysql text to decimal
SQL
4 votes234 views2 answers
Dbms output
SQL
-1 vote213 views2 answers
On update cascade
SQL
0 vote220 views1 answer
Sqlite get date only
SQL
-1 vote301 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
1 vote163 views1 answer
File /etc/init.d/mysql not exists
SQL
4 votes246 views2 answers
Postgresql float data type
SQL
3 votes210 views1 answer
Oracle revoke
SQL
0 vote228 views1 answer
Mysql multiple primary keys
SQL