Group data and pick a particular row based on a condition

Program Name Program Type PIR Cycle#
CE1 Customer Experience 1
CE1 Customer Experience 2
F1 Function 1
PP1 Platform Program 1

I have to group by ProgramName+Program Type and then pick the row with the
max of PIR Cycle# column value

Thanks in advance

What i can do is Sort by ProgramName+programtype+PIR Cycle#(Desc) and then
loop thru all the rows and pick the first occurance. I want to know if there
is any better way of doing this.

Thanks Again

"VishalBade" wrote:

> Program Name Program Type PIR Cycle#
> CE1 Customer Experience 1
> CE1 Customer Experience 2
> F1 Function 1
> PP1 Platform Program 1
>
> I have to group by ProgramName+Program Type and then pick the row with the
> max of PIR Cycle# column value
>
> Thanks in advance
>