>Hi All:
>
>I have a table of deliveries of widgets to various customers.
>
>
>Cust Delivery Date
>1111 3/1/09
>1111 4/1/09
>2222 3/2/09
>3333 3/1/09
>3333 4/5/09
>
>
>How do I say:
>
>Select the 1 record for each customer containing the earliest delivery date?
>
>Thanks,
>
>Yossi
Never mind; you use the MIN() function.