SQL:将表中一列拆成两列

计算tableA表中type列有两种类型，计算每个id的每种类型的count和

    id      type      count
     1       1         10
     2       2          5
     1       1          8
     4       2          9

方法：

select  id
        ,sum(case when type=1 then count  end)  as income
        ,sum(case when type=2 then count  end)  as expenses
from  tableA