SELECT SKT1.SKF6,SKT1.SKF7,SUM(SKT1.SKF128) AS mny,SUM(SKT1.SKF128) / (SELECT SUM(SKT1.SKF128)
FROM SKT1 WHERE SKT1.SKF136 = 1 AND SKT1.SKF4 >= '2018-03' AND SKT1.SKF4 <= '2018-03'),
FROM SKT1 WHERE SKT1.SKF4 >= '2018-03' AND SKT1.SKF4 <= '2018-03' AND SKT1.SKF136 = 1
GROUP BY SKT1.SKF6
ORDER BY MNY DESC
LIMIT 5
總共有120多條資料，我怎么把前五條查出來后，把剩余的合并成一列資料，前兩項合并名為 ‘其他’ ，統計剩余資料的mny 和 后面的百分比
uj5u.com熱心網友回復：
再union all一下另外一條sql limit 5,10000的轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/90938.html
標籤：MySQL