相比的时间段吧? select a.nrs,a.sxse-b.sxse,a.sse-b.sse (select nrs,sum(xse) as sxse,sum(se) as sse from sbb where rq between starttime1 and endtime1 group by nsr ) a,(select nrs,sum(xse) as sxse,sum(se) as sse from sbb where rq between starttime2 and endtime2 group by nsr) b where a.nrs=b.nrs and a.sxse-b.sxse>=0 and a.sse-b.sse<0
select a.nrs,a.sxse-b.sxse,a.sse-b.sse
(select nrs,sum(xse) as sxse,sum(se) as sse from sbb where rq between starttime1 and endtime1 group by nsr ) a,(select nrs,sum(xse) as sxse,sum(se) as sse from sbb where rq between starttime2 and endtime2 group by nsr) b where a.nrs=b.nrs and a.sxse-b.sxse>=0 and a.sse-b.sse<0
请帮个忙,实在是太挠头了。
申报表(SBB)结构如下:
nsr varchar2(20);--纳税人代码
xse number;--当月申报销售额
se number;--当月申报税额
rq date; --申报日期
恳请再次答复,谢谢。