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>