Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Samer Sadek
Ben Nadel at cf.Objective() 2009 (Minneapolis, MN) with: Samer Sadek@samer_sadek )

Eralper

Member since Dec 11, 2008

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-rows-foreach-category-or-group.aspx... read more »