[SQL] picking max from list

[Jodi Kanter]

I have a query that produces results similar to this: run#      rd_pk      group# 0            9209      5   1            9209      8 0            9520      2 1            9520      5 0            9520   etc.... 0            8652 1            8652 2            8652 0            8895   1            8894 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? Thanks Jodi -- _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 [EMAIL PROTECTED]