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 r
On Wed, Dec 10, 2003 at 15:37:10 -0500,
Jodi Kanter <[EMAIL PROTECTED]> wrote:
> I have a query that produces results similar to this:
>
> run# rd_pk group#
> 09209 5
> 19209 8
> 09520 2
> 19520 5
> 09520
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
