mysql - 将数据分为前 20% 的贡献

Question

SELECT priceEach,
CASE WHEN SUM((priceEach/(priceEach) * 100) BETWEEN 19 AND 20 THEN 'yes' ELSE NULL hm
FROM orderdetails
WHERE hm = 'yes'
ORDER BY priceEach DESC;

这行得通吗？

我不知道如何找到占总价格 20% 的部分

Answer 1

这个答案完全基于我对问题的理解。不确定您是否正在寻找这个结果。请尝试这个:

SELECT priceEach,
       CASE WHEN SUM((priceEach/(priceEach) * 100) BETWEEN 19 AND 20 THEN 'yes' ELSE NULL END hm
FROM orderdetails
ORDER BY priceEach DESC
having Count(CASE WHEN SUM((priceEach/(priceEach) * 100) BETWEEN 19 AND 20 THEN 1 ELSE 0 end) = 1;