Re: Help with SELECT query
From: Bob Badour <bbadour_at_golden.net>
Date: Fri, 26 Nov 2004 16:34:37 -0500
Message-ID: <sbudnfb5MroPPDrcRVn-gQ_at_golden.net>
Date: Fri, 26 Nov 2004 16:34:37 -0500
Message-ID: <sbudnfb5MroPPDrcRVn-gQ_at_golden.net>
Marco wrote:
> My SELECT query returns a data set, one column of which contains a set
> of values corresponding to the same date. I.e. for each date in column
> "Date", I have a set of numbers in column "Numbers". However, I am
> only interested in getting the largest value in column "Numbers"
> corresponding to each value in column "Date". How do I do that?
> Thanks,
>
> Marco
Look up MAX and GROUP BY. Received on Fri Nov 26 2004 - 22:34:37 CET