Re: SQL help

try:
select id,date
from visits
where rank = (select max(rank) from visits);

I.K.

H. John C. Hopkins <john_spam_free_at_hpe.ufl.edu> wrote in article <6357rv$oes_at_no-names.nerdc.ufl.edu>...
> Table VISITS
> Fields ID, DATE, RANK
>
> ID is not a primary key (i.e., can have multiple occurrences of ID, each
> with different dates and ranks)
>
> Need to select id AND date where highest rank value.
>
> Thanks so much for your input.
>
> -John
>
>
>
>
>
  Received on Sat Nov 01 1997 - 00:00:00 CST