select sum1,sum2,sum3
from
(
select Company_Name,Tax_Type,Tax_Time, sum(Tax_Number) sum1
from tbl
where substr(to_char(tax_time),1,6) = substr(to_char(sysdate,'yyyymmdd'),1,6)
group by Company_Name,Tax_Type,Tax_Time) tbl_a, --'当月所缴金额'表
(
select Company_Name,Tax_Type,Tax_Time, sum(Tax_Number) sum2
from tbl
where substr(to_char(tax_time),1,4) = substr(to_char(sysdate1,'yyyymmdd'),1,4)
group by Company_Name,Tax_Type,Tax_Time) tbl_b ,--'去年所缴总金额'表
(
select Company_Name,Tax_Type,Tax_Time, sum(Tax_Number) sum3
from tbl
group by Company_Name,Tax_Type,Tax_Time) tbl_b --'所有数据的总金额'表
where tbl_a.Company_Name = tbl_b.Company_Name
and tbl_b.Company_Name = tbl_c.Company_Name
and tbl_a.Company_Name = '北京'注意:
1)如果没问题,可以 tbl_a.Company_Name = '北京' 条件分别放到 tbl_a,b,c中。
2)测试去掉注释。
from
(
select Company_Name,Tax_Type,Tax_Time, sum(Tax_Number) sum1
from tbl
where substr(to_char(tax_time),1,6) = substr(to_char(sysdate,'yyyymmdd'),1,6)
group by Company_Name,Tax_Type,Tax_Time) tbl_a, --'当月所缴金额'表
(
select Company_Name,Tax_Type,Tax_Time, sum(Tax_Number) sum2
from tbl
where substr(to_char(tax_time),1,4) = substr(to_char(sysdate1,'yyyymmdd'),1,4)
group by Company_Name,Tax_Type,Tax_Time) tbl_b ,--'去年所缴总金额'表
(
select Company_Name,Tax_Type,Tax_Time, sum(Tax_Number) sum3
from tbl
group by Company_Name,Tax_Type,Tax_Time) tbl_b --'所有数据的总金额'表
where tbl_a.Company_Name = tbl_b.Company_Name
and tbl_b.Company_Name = tbl_c.Company_Name
and tbl_a.Company_Name = '北京'注意:
1)如果没问题,可以 tbl_a.Company_Name = '北京' 条件分别放到 tbl_a,b,c中。
2)测试去掉注释。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货