如果您使用的是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.