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 - 2005-10-03 : 07:52:31
|
| Robert writes "How do I return the top-10 averages for each and every group-by result set thus providing a 'peak' average? Each row in the table represents a 15-minute CPU% average by processor, partition, and date. I'd like to return the avarage of the top 10 rows for 'each' day and by 'processor' and 'partition'" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Top 10 for each group-by 