I am the chief software engineer at Epicenter Consulting, a boutique software
company in New York City that specializes in developing high-end, customized business
solutions using ColdFusion and jQuery.
( more )
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 »