Community T-SQL: MAX vs. TOP 1 – Which is better?? by SSWUG Research (Steve Endow) If you need to get the largest value for a field, should you use MAX in your query? Or should you use TOP 1 with ORDER BY? Read More – Register for a Membership/membership] Read More (Community content)