SQl Query Help.

Try this,

declare @temp table(PKID int, ID int, [Date] date,RoleId int, Status varchar(10))
insert into @temp values
(98853,31936,'2014-02-20',3,'Approved'),
(97782,31936,'2014-04-02',4,'Close'),
(99168,31936,'2014-04-03',3,'Approved'),
(99177,31937,'2014-04-01',3,'Approved'),
(99178,31937,'2014-04-04',4,'Close'),
(99179,31938,'2014-04-01',3,'Approved') 
select * from (
select ID, Max([Date]) as [Date], Min(Status) Status, Max(rn) rn From (
select *,row_number() over (partition by ID order by Date,Status) rn from @temp) x
group by ID
) y
where rn in (1,3)

---

Regards, RSingh