Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select the records which have a max() of a field
Message
 
 
To
17/11/2002 23:07:08
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00723707
Message ID:
00723733
Views:
7
>I was never sure it would give me the exactly the record in which it found the max() value. Probably did this at random back in 2.x, and I never learned to trust it. It's some Field4 that I'm interested in, and I'm still not sure I'd get it this way.

You would not. In this way you should use Sergey's suggestion. I thought, you have only 3 fields :)
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform