Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieve record with max. date from duplicate records
Message
From
26/10/2001 15:35:00
Inge Gunanto
Ausd
Azusa, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Retrieve record with max. date from duplicate records
Miscellaneous
Thread ID:
00573910
Message ID:
00573910
Views:
48
field1, date
campbell,10/01/01
campbell,9/8/00
cristy,5/1/00
cristy,2/2/01

I need SQL select statement that will give me only 1 record per field1, but with the latest date:
campbell, 10/01/01
cristy 2/2/01

CAN ANYBODY HELP????
Thank you all!!!
Next
Reply
Map
View

Click here to load this message in the networking platform