/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 vote188 views1 answer
How many rows affected in sqllite
SQL
0 vote192 views1 answer
Drop-toys-table
SQL
3 votes304 views6 answers
Sql unique select
SQL
1 vote180 views1 answer
Full sql mode
SQL
1 vote191 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote174 views1 answer
Add column to table with default value plsql
SQL
0 vote175 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote237 views1 answer
Osm2pgsql mac
SQL
0 vote206 views1 answer
Create synonym for dblink in oracle
SQL
0 vote164 views1 answer
Generate sequence number in sql server
SQL