[RESOLVED] SQL SERVER 2005 - Top clause

[si_the_geek]

You don't need to create a variable, you can use the Max query directly as a sub-query:

SELECT * 
from tableSample
WHERE total = (SELECT Max(total) FROM tableSample)