Selecting top x number of records per group is something I needed to implement recently, using the build in functions of SQL Server 2005, it can be done quite easily.
Selecting top x records per group basically divides the data into groups based on a particular field, and then order the records only in that group [...]
Filed under: SQL | Tagged: Partition By, Records Per Group, SQL, SQL Server, SQL Server 2005 | 1 Comment »
