Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ordering inside a group
Message
From
14/02/2001 19:45:35
David Stevenson
Stevenson & Associates
St. Petersburg, Florida, United States
 
 
To
14/02/2001 18:54:22
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Ordering inside a group
Miscellaneous
Thread ID:
00476088
Message ID:
00476098
Views:
32
Michel,

If you just needed ONE additional field with the lowest value, you could do this this:
SELECT MIN(Field1) AS somename, Field2, COUNT(*) FROM MyTable ;
GROUP BY 2 INTO CURSOR TEMP
If you need all the fields for that same record, I don't have an idea.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform