MAX and ORDER BY
Posted: Fri Jun 27, 2003 3:59 pm
If a SQL command has both MAX and ORDER BY, which is evaluated first?
A. Take the first MAX hits then apply the ORDER BY ?
B. Take all the hits, apply the ORDER BY, then return the first MAX hits ?
A. Take the first MAX hits then apply the ORDER BY ?
B. Take all the hits, apply the ORDER BY, then return the first MAX hits ?