/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 vote336 views1 answer
Get current date in pyspark sql
SQL
2 votes297 views3 answers
3 days back in sql server
SQL
1 vote309 views1 answer
Duplicating a MySQL table with all the data Command
SQL
1 vote323 views3 answers
Rows, INSERT INTO
SQL
0 vote250 views1 answer
Testing sql queries
SQL
3 votes296 views3 answers
Into in sql
SQL
1 vote331 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
1 vote319 views1 answer
Postgres set sequence value to max id
SQL
61 votes504 views6 answers
Mysql add column
SQL
2 votes284 views3 answers
Application.properties spring boot mysql
SQL