SELECT * FROM [sheet1$A1:C10] a WHERE EXISTS (SELECT COUNT(1) FROM [sheet1$A1:C10] WHERE 类别 = a.类别 AND 销售数量 > a.销售数量 HAVING COUNT(1) < 2) ORDER BY 类别,销售数量 DESC
SELECT * FROM [sheet1$A1:C10] a WHERE EXISTS (SELECT COUNT(1) FROM [sheet1$A1:C10] WHERE 类别 = a.类别 AND 销售数量 > a.销售数量 HAVING COUNT(1) < 2) ORDER BY 类别,销售数量 DESC