效果:
多行多列
一行多列
sql语句:
SELECT
a.mini_ldy_id_from,
max(case a.type when 2 THEN total else 0 end) as bddhNum,
max(case a.type when 3 THEN total else 0 end) as sjBddhNum,
max(case a.type when 4 THEN total else 0 end) as sjMddjNum,
max(case a.type when 5 THEN total else 0 end) as xfButtonNum,
max(case a.type when 6 THEN total else 0 end) as xfFormNum
from (
select
mini_ldy_id_from,type,COUNT(1) as total
from mini_maidian_data d
where mini_ldy_id_from = 1480818136380891137
group by type) a;