oracle 一张两条数据合并为一条数据

Question

本帖最后由 liuzoe 于 2013-08-29 16:49:50 编辑

Answer 1

select sum(d),sum(c),
       sum(decode(b,'住宅',d,0)),
       sum(decode(b,'住宅',c,0)),
       sum(decode(b,'非住宅',d,0)),
       sum(decode(b,'非住宅',c,0))  from table where a=4027 group by a

Answer 2

SELECT SUM(D),
       SUM(C),
       SUM(DECODE(B, '住宅', D, 0)),
       SUM(DECODE(B, '住宅', C, 0)),
       SUM(DECODE(B, '非住宅', D, 0)),
       SUM(DECODE(B, '非住宅', D, 0))
  FROM TABLE
 WHERE A = 4027