17,377
社区成员
发帖
与我相关
我的任务
分享
Select Name,Sum(beijing) as beijing,Sum(wuhan) as wuhan,Sum(tianjing)as tianjing
From
(
Select name,
Case address when 'beijing' then price end as beijing,
Case address when 'wuhan' then price end as wuhan,
Case address when 'tianjing' then price end as tianjing
from test1
)B Group by name
有多少个城市就加多少个类似的SUM(DECODE(ADDRESS, 'beijing', PRICE)) BEIJING;
SELECT NAME,
SUM(DECODE(ADDRESS, 'beijing', PRICE)) BEIJING,
SUM(DECODE(ADDRESS, 'wuhan', PRICE)) WUHAN,
SUM(DECODE(ADDRESS, 'tianjing', PRICE)) TIANJING
FROM PRODUCT
GROUP BY NAME;