MAX and ORDER BY

Post Reply
bill.marel
Posts: 24
Joined: Fri Aug 30, 2002 12:49 pm

MAX and ORDER BY

Post by bill.marel »

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 ?
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

MAX and ORDER BY

Post by mark »

B
Post Reply