SELECT
*
FROM
(
产品名称,
销售额 ,
sum(销售额) over (ORDER BY 销售额 DESC) / sum(销售额) over () AS 累计占比
tabname
) tk
WHERE
累计占比 < 0.85
ORDER BY
销售额 DESC
