Community Member Profile
Eralper
Member since Dec 11, 2008
- Profile: /members/994-Eralper.htm
- URL: http://www.kodyaz.com
- Comments: 1
- Points: 1
Recent Blog Comments By Eralper
-
Selecting Top X From Each Group
Posted on Jan 30, 2008 at 1:21 AM
Hi, There is a good sample selecting top n rows for each group using ROW_NUMBER() OVER (PARTITION BY column1 ORDER BY column2 DESC), look at http://www.kodyaz.com/articles/top-n-random-r... read more »
