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