SQLTeam.com | Weblogs | Forums

Top 3Shop sales group by Salesman

One salesman Nick is selling in 50 shops..and Other salesman Tom is selling in different 80 shops so top 3 shop sales of both the salesman need with amount in single line

Suppose Nick sold in 50 shops and out of top 50 his Top 3 shop sales is -
Shop code A1234 sales is 12 dollar
Shop code A1235 sales is 100 dollar
Shop code A1236 sales is 150 dollar

I need top 3 so sales will be

Employe Name Top3_Shop_Sales
** Nick 262 ** ** Tom 536**

Please provide create table statement(s) and insert statements to set up a sample respondents can use to provide a solution. Please provide the desired result using the sample data you provide. Thank you