Re: Help!!! - Select the Max of a Distinct Set

Use group by, not distinct. Likely you will need a superquery or subquery to get the max date.

Daniel Morgan

Lucas Tam wrote:

> Hi all... I'm having some trouble with a query I need to write.
>
> I have a table with the following columns:
>
> ID Date Group O/S ASIC Misc Columns
>
> I need to select the Latest Distinct Records based on Group + OS + ASIC
> based on date.
>
> How do I do this?
>
> Thanks.
Received on Thu Apr 25 2002 - 18:26:23 CDT