How do I change this query to ensure that it returns the top 25 salespersons based on total sales dollars? Select top 25 salescategory, salesperson, sum(salesdollars) from salestbl where salesdate between '1/1/09' and '1/31/09'

54.

How do I change this query to ensure that it returns the top 25 salespersons based on total sales dollars?

Select top 25 salescategory, salesperson, sum(salesdollars)
from salestbl
where salesdate between '1/1/09' and '1/31/09'

move sum(salesdollars) next to the top 25 portion of the select statement

add an 'order by salesperson' to the end of the statement

add an 'order by sum(salesdollars) desc' to the end of the statement

No description found.