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 |
|
parry
Starting Member
1 Post |
 Posted - 2005-11-21 : 10:48:53
|
| How do I write query that display top 100 ppl from each group(around 120 groups) by their salary (high to low). Each group has unique number. There is only one table. Each group has several members(around 250). grpid memid sal001 8547 9857001 8524 1479... 002 8584 8957001 4271 2418 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-21 : 11:12:10
|
http://weblogs.sqlteam.com/mladenp/archive/2005/08/01/7421.aspxlook at point 2Go with the flow & have fun! Else fight the flow  |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2005-11-21 : 17:03:14
|
| (Moved to the T-SQL forum)-graz===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
|
|
|
how to qury to get top 100 ppl from each group?