select sum(case 字段1 when ‘支付宝’ then 字段2 else 0 end) as 1, sum(case 字段1 when ‘工行’ then 字段2 else 0 end) as 2, sum(case 字段1 when ‘交行’ then 字段2 else 0 end) as 3, sum(case payType when ‘中行’ then 字段2 else 0 end) as 4 from 表`
主要是通过Sum、Case Whenselectsum(case 字段1 when ‘支付宝’ then 字段2 else 0 end) as 1,sum(case 字段1 when ‘工行’ then 字段2 else 0 end) as 2, sum(case 字段1 when ‘交行’ then 字段2 else 0 end) as 3,sum(case payType when ‘中行’ then 字段2 else 0