为每个类别选择前10条记录 [英] Select top 10 records for each category

问题描述

我想在一个查询中返回每个部分的前10条记录.任何人都可以帮忙吗? Section是表中的列之一.

I want to return top 10 records from each section in one query. Can anyone help with how to do it? Section is one of the columns in the table.

数据库是SQL Server2005.我想按输入的日期返回前十名.这些部分是业务，本地和功能.对于一个特定的日期，我只需要前(10)个业务行(最近输入)，前(10)个本地行和前(10)个功能.

Database is SQL Server 2005. I want to return the top 10 by date entered. Sections are business, local, and feature. For one particular date I want only the top (10) business rows (most recent entry), the top (10) local rows, and the top (10) features.

推荐答案

如果您使用的是SQL 2005，则可以执行以下操作...

If you are using SQL 2005 you can do something like this...

SELECT rs.Field1,rs.Field2 
    FROM (
        SELECT Field1,Field2, Rank() 
          over (Partition BY Section
                ORDER BY RankCriteria DESC ) AS Rank
        FROM table
        ) rs WHERE Rank <= 10

如果RankCriteria有关系，那么您可能会返回10行以上，而Matt的解决方案可能更适合您.

If your RankCriteria has ties then you may return more than 10 rows and Matt's solution may be better for you.

这篇关于为每个类别选择前10条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！