Re: SQL help

On Tue, 28 Oct 1997 12:34:24 -0500, "H. John C. Hopkins" <john_spam_free_at_hpe.ufl.edu> wrote:

>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
>
>
>

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

If there are several rows with the same highest rank, they will all be selected.

--
Chuck Hamilton
Xchuckh_at_dvol.com
In an effort to reduce spam my return email address hasbeen changed.
To reply, remove the X from the beginning.

If at first you don't succeed, sky diving isn't for you.