sql实现表数据转置-列转行

纵向转横向：

FEE_FLAG 为标识字段，根据该字段将ACCT_USERS、TOTAL_FEE_ALL转换成对应标识的数据（FEE_FLAG ：01流失02新发展03回归04递延，CHANGE_PRODUCT_FLAG：01迁入02迁出03不变），CHANGE_PRODUCT_FLAG为递延下分类字段。

select s.node_name,  MONTH_ID  ,    t.NODE_ID   , PRODUCT_ID , 
  sum (ACCT_USERS) ACCT_USERS,
       SUM(ACCT_USERS) - SUM(L_ACCT_USERS) USER_VAR,
       case
         when SUM(L_ACCT_USERS) != 0 then
          (SUM(ACCT_USERS) - SUM(L_ACCT_USERS)) / SUM(L_ACCT_USERS)
         else
          0
       end USER_HB,
        sum(TOTAL_FEE_ALL) TOTAL_FEE_ALL,
       case
         when SUM(L_TOTAL_FEE) != 0 then
          (SUM(TOTAL_FEE_ALL) - SUM(L_TOTAL_FEE)) / SUM(L_TOTAL_FEE)
         else
          0
       end FEE_HB,
        sum(case when FEE_FLAG='04' and CHANGE_PRODUCT_FLAG='01' then ACCT_USERS else 0 end ) INPUT_USERS,
        sum(case FEE_FLAG when '02' then ACCT_USERS else 0 end ) DEV_USERS_NEW,
        sum(case FEE_FLAG when '03' then ACCT_USERS else 0 end ) BACK_USERS,
        sum(case FEE_FLAG when '04' then ACCT_USERS else 0 end ) DIYAN_USERS,
        sum(case when FEE_FLAG='04' and CHANGE_PRODUCT_FLAG='01' then TOTAL_FEE_ALL else 0 end ) INPUT_USERS_FEE,
        sum(case FEE_FLAG when '02' then TOTAL_FEE_ALL else 0 end ) DEV_USERS_NEW_FEE,
        sum(case FEE_FLAG when '03' then TOTAL_FEE_ALL else 0 end ) BACK_USERS_FEE,
        sum(case FEE_FLAG when '04' then TOTAL_FEE_ALL else 0 end ) DIYAN_USERS_FEE
  from eba.dm_m_prd_ana_charge t join dim.dim_node_id_n_STATIC_V s on t.node_id=s.node_id 
      where t.month_id = '201710' 
and s.parent_id = '760' 
and t.product_id = '90063345' 
and FEE_FLAG='02'
      group by  s.node_name,  MONTH_ID,  t.NODE_ID   ,    PRODUCT_ID