/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 vote362 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote377 views3 answers
How to assign custom id in mysql
SQL
0 vote334 views1 answer
Drop all tables in azure sql database
SQL
0 vote393 views2 answers
Identity syntax in sql
SQL
17 votes346 views3 answers
Cast in sql server
SQL
0 vote346 views1 answer
Sql server sleep
SQL
0 vote335 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote351 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote331 views1 answer
Mysql remove tabs from string
SQL
0 vote337 views1 answer
Bash block size ls /var/lib/mysql
SQL