血泪

摘要： 表Name state countLee aaa 20Lee bbb 10Lee ccc 30查询后显示姓名 aaa bbb cccLee 20 10 30select name1 as 姓名 , sum(case state when 'aaa' then count1 else 0 end) aaa, sum(case state when 'bbb' then count1 else 0 end) bbb, sum(case state when 'ccc' then count1 else 0 end) cccfrom testlungr 阅读全文