Re: Help with SELECT query

mdi00_at_hotmail.com (Marco) wrote in news:e5f1d809.0411190312.c9f8b07 _at_posting.google.com:

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

SELECT "Date", MAX("Numbers")AS "Largest number" FROM sometable
GROUP BY "Date" Received on Fri Nov 19 2004 - 14:20:30 CET