Sorry
I’m trying to get the last active year for the individual user and insert that year as a new column (Status) for that particular user.

Create table latest_value(year int,[name] varchar(50),last_active varchar(50))
go
Insert into latest_valueSelect 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

I hope this make some sense?

Thank you