Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Earliest date
Message
From
25/07/2011 17:30:33
 
 
To
25/07/2011 17:17:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01519110
Message ID:
01519112
Views:
43
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform