Re: distinct

[Luana Carter]

mared82 wrote:
> I need to use Distinct to return unique records by
> order number but I also need to return the rest of
> fields that are not part of the Distinct. For
> example:
>
> SELECT Num, Type, Customer FROM Order_Table
>
> Num Type Customer
> ------ ------ ------------
> 1 YY 1001
> 1 AA 1001
> 2 SD 2001
> 3 CC 5000
> 3 BB 5000
>
>
> I would like to use Select Distinct by number but
> return more than just the number field. Type and
> Customer also need to be returned like below
> example:
>
> Num Type Customer
> ------ ------ ------------
> 1 YY 1001
> 2 SD 2001
> 3 CC 5000
>
> Is there a way to solve this? Thank you in
> advance!!