ghollis (3/18/2009)
I agree with the previous comment that even with a group by, top 25, and order by, you are not going to get what the question asked for as the group by would have to group on the salescategory and salesperson; whereas, the question asked for the top 25 sales people, so salescategory would need to be removed.
I agree. Someone participating in multiple 'salescategories' could actually be the top 'salesperson'
Greg E