/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 vote214 views1 answer
Opensuse start MySQL
SQL
0 vote229 views1 answer
Write sql query to show the details start from digit
SQL
0 vote236 views1 answer
T-SQL - Where Used List (Table/View)
SQL
1 vote217 views1 answer
Sql delete all values in a column
SQL
10 votes241 views4 answers
Drop primary key
SQL
0 vote232 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
4 votes217 views1 answer
Check database name postgresql
SQL
4 votes219 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote225 views1 answer
Json not contains mysql
SQL
4 votes210 views1 answer
Fetch first 10 rows in oracle sql developer
SQL