/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 vote175 views2 answers
Drop check constraint in ms sql
SQL
0 vote209 views1 answer
Sql query use select name inside where clause
SQL
0 vote180 views1 answer
Mysql select where field like in list
SQL
3 votes197 views2 answers
Postgresql select all column names
SQL
1 vote198 views1 answer
Drop primary key oracle
SQL
0 vote214 views1 answer
Sql order by number not ordered
SQL
11 votes209 views3 answers
Sql line numbers
SQL
3 votes169 views1 answer
Oracle nextval
SQL
1 vote192 views1 answer
Display total number of tables in mysql
SQL
0 vote194 views1 answer
Compare if is null sql
SQL