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 和 后面的百分比
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 和 后面的百分比
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货