问题描述 测试库需要一个查询各单位、各客户类型的客户容量前N名的sql。 结果SQL select * from (select c.sub_company_id, c.customer_type, c.customer_name, c.capacity , ROW_NUMBER() OVER(PARTITION BY sub_company_id, customer_type ORDER BY capacity desc ) AS cnt from customer c) aa where aa.cnt <= 10