Status with latest date

[Kamran1991]

Hi folks,

I have a dummy data, wherein I have some job IDs. There are multiple statuses with their corresponding dates, with each ID. 

I want the latest date for every ID and its associated status.

Any help to solve this problem would be highly appreciated.

Anticipatory thanks,

Kamran

 

 

[binuacs · Accepted solution]

@Kamran1991 One way of doing this

[Kamran1991 · Accepted solution]

Thanks @binuacs.

It works.