MYSQL 横向统计查询

2019独角兽企业重金招聘Python工程师标准>>>

表ORDER ，字段|FAMILY|AMOUNT|

例：

select sum( case `FAMILY` when '线下订单' then 1  else 0 end)as col1,
        sum( case `FAMILY` when '手机订单' then 1 when '网络订单' then 1 else 0 end)as col2,
        sum(case `FAMILY` when '线下订单' then AMOUNT else 0 end) as col3,
        sum(case `FAMILY` when '手机订单' then AMOUNT when '网络订单' then AMOUNT else 0 end) as col4
        from ORDER as o 
        where o.STATUS in ('线下订单','手机订单','网络订单')  

转载于:https://my.oschina.net/jingshishengxu/blog/806727