简单的行列转换

create table testTab
(
  id varchar(10),
  num number,
  ran number
)

  insert into testTab (id,num,ran) values('a',1,1);
  insert into testTab (id,num,ran) values('a',2,1);
  insert into testTab (id,num,ran) values('b',2,2);
  insert into testTab (id,num,ran) values('a',2,2);
  
  
  select id,
  sum(decode(ran,ran,num)) as 总量,
  ran 所在仓库
  from testTab 
  group by id,ran