Home Forums Article Discussions Article Discussions by Author Discuss content posted by Robert Griffin T-SQL - SELECT TOP RE: T-SQL - SELECT TOP
Lynn Pettis
SSC Guru
Points: 442467
More actions
March 19, 2009 at 11:13 am
#962927
Yes, there are issues with the query itself, but what did the question ask? How do you ensure you get the top 25 in sales. The only answer that works there is that you also need to add an ORDER BY SUM(salesdollars) DESC.