Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
crispbd
Starting Member
2 Posts |
 Posted - 2005-05-06 : 12:16:29
|
| I want to return a list of items, but for each item, list thetop 5 matches for a criteria (say.. sales regions) how do i do this? I've tried using the 'top' keyword but find it difficult to have it applied to every part in the list. Here is the basic result set that I'm looking to generate:Item Regionitem1 Canadaitem1 Germanyitem1 Swedenitem2 Germanyitem2 Franceitem2 Russiaetc. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
crispbd
Starting Member
2 Posts |
Posted - 2005-05-06 : 12:47:26
|
| Thanks a lot! |
 |
|
|
|
|
|
Returning top 5 sales regions for part list