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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-19 : 09:01:52
|
Alexander writes "Hello:I have a View that returns the top 10 rated submissions from various users.How do I retrieve the top 5 rated submissions of 5 distinct users from the result set?Below is the result set returned by the View: ID userID UserName Rating ============================= 436 100184 Teardrop 4.56 401 100151 Lisa_J 4.54 398 100151 Lisa_J 4.53 245 100131 mkp1151 4.53 411 100151 Lisa_J 4.52 193 100443 Laryalee 4.50 622 100220 ainsleyjo 4.50 556 100131 mkp1151 4.50 226 100131 mkp1151 4.50 340 100184 Teardrop 4.50 " |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-19 : 09:15:17
|
| therez an article by Graz "whats after top?" on this site. read it , it will help u.you can check for top and distinct statement in BOL tht will help .-------------------------"Success is when Preparedness meets Opportunity"Edited by - Nazim on 12/19/2001 09:15:59 |
 |
|
|
|
|
|
Selecting the highest IDs from distinct users