create procedure Upro
as
insert into t2
select
(select 数量 from t1 where 省市=1) ,
(select 数量 from t1 where 省市=1),
(select 数量 from t1 where 省市=1)
as
insert into t2
select
(select 数量 from t1 where 省市=1) ,
(select 数量 from t1 where 省市=1),
(select 数量 from t1 where 省市=1)
create procedure Upro
as
insert into t2
select
(select 数量 from t1 where 省市=1) ,
(select 数量 from t1 where 省市=2),
(select 数量 from t1 where 省市=3)
as
insert into t2
select
(select sum(数量) from t1 where 省市=1) ,
(select sum(数量) from t1 where 省市=2),
(select sum(数量) from t1 where 省市=3)
create procedure Upro
as
insert into t2
select
(select sum(数量) from t1 where 省市=1) ,
(select sum(数量) from t1 where 省市=2),
(select sum(数量) from t1 where 省市=3)
数量 省市编号
20 1
50 3
70 5t2:
省市名 编号
上海 1
北京 3
广州 5
t3:
上海 北京 广州
20 50 70
select sum(case 省市 when 1 then 数量 else 0 end),
sum(case 省市 when 2 then 数量 else 0 end),
sum(case 省市 when 3 then 数量 else 0 end)
from t1