Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The max value of a given group
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00887108
Message ID:
00887455
Views:
9
You're welcome.

>Thanks Sergey, that did it.
>
>
>
>>
>>Try
* Get key fields for oldest members
>>SELECT Family, Level, MAX(Age) AS Age ;
>>	FROM mytable ;
>>	GROUP BY 1,2 ;
>>	INTO CURSOR crsOldestKey NOFILTER
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform