结合视图user_tab_column能行吗?说明 A B C 77 88 99该结果不是通过子查询查出的,即 select sum(s.cjs) as cjs , sum(s.jyfjf) as jyfjf, sum(s.dfjyfj) as dfjyfj from (select n.nsrsbm from (select ys_dm from city_level) s inner join nsr_jc n on s.ys_dm = n.skzh_id ) m, ssbd s where m.nsrsbm = s.nsrsbh
SQL2005 : -------------------------------------------- create table aaa(a int,b int ,c int)insert into aaa values(77,88,99)select * from aaa unpivot (vaa for bb in ([a],[b],[c])) as pvtdrop table aaa-------------------------------------------
DECODE是行转列
A B C
77 88 99该结果不是通过子查询查出的,即
select
sum(s.cjs) as cjs , sum(s.jyfjf) as jyfjf, sum(s.dfjyfj) as dfjyfj
from
(select
n.nsrsbm
from
(select ys_dm from city_level) s
inner join nsr_jc n on s.ys_dm = n.skzh_id
) m, ssbd s
where m.nsrsbm = s.nsrsbh
--------------------------------------------
create table aaa(a int,b int ,c int)insert into aaa values(77,88,99)select * from aaa
unpivot (vaa for bb in ([a],[b],[c])) as pvtdrop table aaa-------------------------------------------