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