select value from previous row in postgresql

Confused Centipede answered on August 10, 2021 Popularity 7/10 Helpfulness 4/10

answer select value from previous row in postgresql

select value from previous row in postgresql

Comment

-- 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;

Popularity 7/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: postgresql row select sql

Link to this answer
Share Copy Link

Contributed on Aug 10 2021

Confused Centipede

0 Answers Avg Quality 2/10

Closely Related Answers

postgresql get previous row

Comment

SELECT 
    column_name,
    LAG(column_name) OVER (ORDER BY sort_column) AS previous_row
FROM 
    table_name;

Popularity 4/10 Helpfulness 2/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

select value from previous row in postgresql

Contents

More Related Answers

select value from previous row in postgresql

Closely Related Answers

postgresql get previous row

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.