/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 vote143 views1 answer
Wordpress change url phpmyadmin
SQL
2 votes122 views1 answer
Mysql select default if null
SQL
0 vote116 views1 answer
Plsql check for string in numeric
SQL
-1 vote99 views1 answer
Add column alter table default value
SQL
3 votes108 views4 answers
Ubuntu stop mysql
SQL
1 vote138 views1 answer
Homebrew install mysql
SQL
0 vote117 views1 answer
How to get button for every record from mysql
SQL
3 votes110 views2 answers
Df to sql pandas sql achemy
SQL
0 vote116 views1 answer
Sql server beginning of month
SQL
0 vote115 views1 answer
How to insert multiple rows in mysql using laravel
SQL