问题一:
select t1.hy_dm,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm问题二:
select b.nsrsbh,b.ynse,b.ysxssr,a.fs
from (select t1.hy_dm,t1.nsrsbh ,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm,t1.nsrsbh ) a ,
ybnsr b ,
(select t1.hy_dm,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm) c
where a.nsrsbh=b.nsrsbh and a.hy_dm=c.hy_dm and a.fs<b.fs
注:
(select t1.hy_dm,t1.nsrsbh ,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm,t1.nsrsbh ) a
单位的行业税负,where 后面可以加日期过滤(select t1.hy_dm,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm) c
行业税负
select t1.hy_dm,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm问题二:
select b.nsrsbh,b.ynse,b.ysxssr,a.fs
from (select t1.hy_dm,t1.nsrsbh ,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm,t1.nsrsbh ) a ,
ybnsr b ,
(select t1.hy_dm,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm) c
where a.nsrsbh=b.nsrsbh and a.hy_dm=c.hy_dm and a.fs<b.fs
注:
(select t1.hy_dm,t1.nsrsbh ,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm,t1.nsrsbh ) a
单位的行业税负,where 后面可以加日期过滤(select t1.hy_dm,case sum(ysxssr) when 0 then 0 else sum(ynse)/sum(ysxssr) end fs
from ybnsr t1,nsrsbh t2 where t1.nsrsbh=t2.nsrsbh
group by t1.hy_dm) c
行业税负
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货