Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The max value of a given group
Message
From
17/03/2004 11:44:27
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: The max value of a given group
Miscellaneous
Thread ID:
00887108
Message ID:
00887119
Views:
10
Hi Enmanuel!

Try this:
Select Family, Name, Max(Age) Age, Level From myTable Group By Family, Level
I hope this help you.
Bye!
Erick
Força Sempre!
Strength Always!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform