Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can this be done with SQL statement
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Can this be done with SQL statement
Miscellaneous
Thread ID:
00728373
Message ID:
00728373
Views:
44
Hi.
I'm wondering is there a SQL statemnt to do the following:

My File has two fields:
Flda Fldb
---- ----
A 100
A 200
A 300
D 105
D 107
E 153
E 156

I want as a result:
A 300
D 107
E 156
i.e. The highest record based on the Flda field

Regards

Gerard
Next
Reply
Map
View

Click here to load this message in the networking platform