picking max from list

I have a query that produces results similar to this:<br /><br /> run#      rd_pk      group#<br /> 0           
9209     5   <br /> 1            9209      8<br /> 0            9520      2<br /> 1            9520      5<br /> 0     
     9520   etc....<br /> 0            8652<br /> 1            8652<br /> 2            8652<br /> 0            8895  
<br/> 1            8894<br /><br /> Ultimately I want to know the group number for EACH rd_pk with the highest run
number.Can this be done in one query? Or will I need to code with a loop?<br /> Thanks<br /> Jodi<br /><div
class="moz-signature">--<br /></div><div class="Section1"><p class="MsoNormal"><i><span style="font-size: 9pt;
font-family:Arial;">_______________________________<br /></span></i><i><span style="font-size: 10pt;">Jodi L Kanter<br
/>BioInformatics Database Administrator<br /> University of Virginia<br /> (434) 924-2846<br /><a
href="mailto:jkanter@virginia.edu">jkanter@virginia.edu</a></span></i><spanstyle="font-size: 11pt; font-family:
Arial;"><brstyle="" /><br style="" /></span><p class="MsoNormal"><span style="font-size: 11pt; font-family:
Arial;"> </span><pclass="MsoNormal"><i><span style="font-size: 9pt; font-family: Arial;"> </span></i><p
class="MsoNormal"><i><spanstyle="font-size: 9pt; font-family: Arial;"> </span></i></div>