/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 votes249 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote226 views1 answer
T sql dynamic top n query
SQL
0 vote204 views1 answer
Mysql count by month
SQL
20 votes197 views4 answers
Reset auto increment in MySQL
SQL
1 vote202 views2 answers
Mysql extract month
SQL
5 votes199 views1 answer
Ascending order and where in sql
SQL
0 vote203 views1 answer
Mysql find missing values
SQL
0 vote207 views2 answers
Sql use not in
SQL
0 vote221 views1 answer
Updating database in sql
SQL
9 votes235 views3 answers
Sql delete where in
SQL