HI,
I’m trying to get the last active data and insert that in the current row of the table. Create table latest_value ( year int, [name] varchar(50), last_active varchar(50) )
go
Insert into latest_value Select 2010, 'Avinash', 'active' Union All Select 2011, 'Avinash','active' Union All select 2010,'Rahul','active' Union All Select 2012, 'Avinash','inactive'
SELECT * FROM latest_value
year name last_active
2010 Avinash active
2011 Avinash active
2010 Rahul active
2012 Avinash inactive
Desired output
year name last_active Status
2010 Rahul active 2010
2012 Avinash inactive 2011
Thanks in advance for the help!