Re: picking max from list

select group,rd_pk
from (select ...) as your_query,
(select max(run) as max_run,rd_pk as rd
from (select ...) as your_query) as max_rd
where rd = rd_pk
and max_run = run;

I dont know if you call that one query but it should work.

There may be more elegant solutions, but I havn't had a chance to read
up on the new join types.

Good luck

Jodi Kanter wrote:

> 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

--
Guy Fraser
Network Administrator