Re: SQL help

SELECT 	id,date,max(rank)
FROM		visits
GROUP BY	id,date;
	

"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
>
>
>
>
Received on Wed Oct 29 1997 - 00:00:00 CST