行转列的问题能帮我解决一下不？？我是oracle数据库

Question

代码如下

 select t.SBDL_DM as, sum(decode(t.SYZT_MC, t.num, 1)) as "在用",
       sum(decode(t.SYZT_MC, t.num, null)) as "停用",
       sum(decode(t.SYZT_MC, t.num, null)) as "注销",
       sum(decode(t.SYZT_MC, t.num, null)) as "报废",
       sum(decode(t.SYZT_MC, t.num, null)) as "备注",
       sum(decode(t.SYZT_MC, t.num, null)) as "告知",
       sum(decode(t.SYZT_MC, t.num, null)) as "未知"
  from (select SBDL_DM,SYZT_MC,count(*) as num  from T_TZSB_JBXX  group by SYZT_MC,SBDL_DM
) t
  group by t.SBDL_DM

Answer 1

http://www.cnblogs.com/nick-huang/p/3836061.html