mysql 行转列

SELECT
ifnull(CODE, 'total') AS CODE,
sum(IF(dd = '1', quantity, 0)) AS '1',
sum(IF(dd = '2', quantity, 0)) AS '2',
sum(IF(dd = '3', quantity, 0)) AS '3',
sum(IF(dd = '4', quantity, 0)) AS '4',
sum(IF(dd = '5', quantity, 0)) AS '5',
sum(IF(dd = '6', quantity, 0)) AS '6',
sum(IF(dd = '7', quantity, 0)) AS '7',
sum(IF(dd = '8', quantity, 0)) AS '8',
sum(IF(dd = '9', quantity, 0)) AS '9',
sum(IF(dd = '10', quantity, 0)) AS '10',
sum(IF(dd = '11', quantity, 0)) AS '11',
sum(IF(dd = '12', quantity, 0)) AS '12',
sum(IF(dd = '13', quantity, 0)) AS '13',
sum(IF(dd = '14', quantity, 0)) AS '14',
sum(IF(dd = '15', quantity, 0)) AS '15',
sum(IF(dd = '16', quantity, 0)) AS '16',
sum(IF(dd = '17', quantity, 0)) AS '17',
sum(IF(dd = '18', quantity, 0)) AS '18',
sum(IF(dd = '19', quantity, 0)) AS '19',
sum(IF(dd = '20', quantity, 0)) AS '20',
sum(IF(dd = '21', quantity, 0)) AS '21',
sum(IF(dd = '22', quantity, 0)) AS '22',
sum(IF(dd = '23', quantity, 0)) AS '23',
sum(IF(dd = '24', quantity, 0)) AS '24',
sum(IF(dd = '25', quantity, 0)) AS '25',
sum(IF(dd = '26', quantity, 0)) AS '26',
sum(IF(dd = '27', quantity, 0)) AS '27',
sum(IF(dd = '28', quantity, 0)) AS '28',
sum(IF(dd = '29', quantity, 0)) AS '29',
sum(IF(dd = '30', quantity, 0)) AS '30',
sum(IF(dd = '30', quantity, 0)) AS '30',
SUM(quantity) AS TOTAL
FROM
instock
WHERE
mm = 8
GROUP BY
CODE WITH ROLLUP;
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值