可以用开窗试试
select * from (select *,row_number(partition by 产品名称 order by 销售额 desc) as num from 表) where num <=2
select TOP 2 * from (select 产品名称,sum(销售额) as 销售额 from table) order by 销售额