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:
00887453
Views:
10
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
>
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform