Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get 1st record if duplicate records found?
Message
From
30/10/2001 17:55:26
Inge Gunanto
Ausd
Azusa, California, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Get 1st record if duplicate records found?
Miscellaneous
Thread ID:
00575370
Message ID:
00575370
Views:
38
field1,field2
abarca,2243
abarca,3314
abarca,2142

I need to get the 1st record: abarca, 2243.
SELECT * from table1 GROUP BY field1: returns the last record (abarca, 2142).
What would be the correct SQL statement to do so?

Thank you all!
Next
Reply
Map
View

Click here to load this message in the networking platform