>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