If you've ever been asked to return the top 3 sales people in a technical test and thought it will be a walk in the park till you actually attempted it. Sounds simple enough, sum the sales, group by sales person and it is at this point that I came unstuck the first time I tackled it many moons ago. Well I've posted a page that explains how to do this and has some sample code for you. I use the AdventureWorks2012 database so it should be easy enough for you to reuse my code on your own system. The page is here:
click here to open page with explanation and sample code
No comments:
Post a Comment