/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

3 votes387 views1 answer
Two select sql
SQL
0 vote354 views1 answer
Ignore case in string sql
SQL
1 vote344 views1 answer
Increase date by one day in sql oracle
SQL
92 votes654 views6 answers
Substring
SQL
0 vote380 views1 answer
Default order by in mysql
SQL
3 votes384 views1 answer
Increment integer in table sql
SQL
0 vote358 views1 answer
Windows services sql
SQL
0 vote356 views1 answer
Foreign key multiple columns
SQL
0 vote352 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote396 views1 answer
Drop domain postgresql
SQL