17,090
社区成员
发帖
与我相关
我的任务
分享
with t(单位, 月份, 类型, 零售金额, 折扣金额) as (
select 'SH', '201208', '坐垫', 80000, 900 from dual
union all select 'SH', '201208', '把手', 70000, 600 from dual
union all select 'SH', '201208', '前叉', 120000, 1200 from dual
)
select 单位, 月份, '零售金额' as 类型,
sum(decode(类型, '坐垫', 零售金额)) as 坐垫,
sum(decode(类型, '把手', 零售金额)) as 把手,
sum(decode(类型, '前叉', 零售金额)) as 前叉
from t group by 单位, 月份
union all
select 单位, 月份, '折扣金额' as 类型,
sum(decode(类型, '坐垫', 折扣金额)) as 坐垫,
sum(decode(类型, '把手', 折扣金额)) as 把手,
sum(decode(类型, '前叉', 折扣金额)) as 前叉
from t group by 单位, 月份;