table1(xsb)
fieldname type
销售流水号 VACHAR 10
类型 VACHAR 4
名称 VACHAR 50
销售数量 DEMICAL 9,2
金额 DEMICAL 18,2
TALBE(JHB)
FIELDNAME TYPE
计划数 DEMICAL 18,2
类型 VACHAR 4
fieldname type
销售流水号 VACHAR 10
类型 VACHAR 4
名称 VACHAR 50
销售数量 DEMICAL 9,2
金额 DEMICAL 18,2
TALBE(JHB)
FIELDNAME TYPE
计划数 DEMICAL 18,2
类型 VACHAR 4
from (
select 类别,sum(销量) as 销量 from 实绩销售 group by 类别 ) a,
(
select 类别,sum(计划量) as 计划量 from 计划 group by 类别 ) b
where a.类别=b.类别
from (
select 类型,sum(销售数量) as 销售数量 from 实xsb group by 类型 ) a right join JHB b
on a.类型=b.类型
,sum(销售数量) * 100 / (select sum(销售数量) from xsb)
,sum(销售数量) * 100 / (select sum(计划数) from JHB where 类型 = T.类型)
from xsb T
group by 类型
,sum(销售数量) * 100 / (select sum(销售数量) from xsb) as 占实际总量百分之
,sum(销售数量) * 100 / (select sum(计划数) from JHB where 类型 = T.类型) as 占该类型计划数百分之
from xsb T
group by 类型
,sum(销售数量) * 100 / (select sum(销售数量) from xsb) as 占实际总量百分之
,sum(销售数量) * 100 / (select sum(计划数) from JHB where 类型 = T.类型) as 占该类型计划数百分之
from xsb T
group by 类型
`