多缴100万以上户数（负向）.docx

多缴100万以上户数(负向)一多缴100万以上户数SE1.ECT+PARA1.1.E1.(4)*/nvl(n.sh×ydm,n.nsrsbh)社会信用代码，n.NSRMC纳税人名称,×m.zsxmmc征收项目，tts.ttsflxmc提退税费类型，MAX(m.SE)多缴金额，n.dsswjgmc地市税务机关，n.QXSWJGMC区县税务机关，n.KSSWJGMC科所税务机关，n.Ssglyswrymc税收管理员，to_char(sysdate；yyyymm')数据加工月份FROM(SE1.ECTT.NSRDZDAH,ZSXMD,TTSF1.X_ID,YDTXH,SUM(SE)OVERfPARTITIONBYT.NSRDZDAH,ZSXMD,TTSF1.XJD)SE,SUM(SE)OVERfPARTITIONBYT.NSRDZDAH)SE_HZ,t.skssqq,t.skssqzzt.djfsrqFROMSJCK_BZ.ZS_YDTXXTWHERET.ZSXMJD1.IKE,101%'ANDT.DJFSRQ<fxqjqANDT.11SF1.X-IDIN(,03,04,z,99')ANDT.SKC1.1.XJDNOTIN(,2,4,)ANDT.SWJGJD1.IKE,14101%,)mjoinWD_NSRXXnonm.NSRDZDAH=n.NSRDZDAHjoinwd_zsxmxmonm.ZSXMJD=xm.ZSXM_IDjoinwd_TTSF1.Xttsonm.TTSF1.XJD=tts.TTSF1.XJDWHEREm.SE_HZ>1000000andn.dsswjg_dm=dsswjg_dmGROUPBYnvl(n.shxydm,n.nsrsbh),n.NSRMCzxm.zsxmmcztts.ttsflxmc,n.dsswjgmc,n.QXSWJGMC,n.KSSWJGMC,n.SSgIyswrymc,(iUJUJAAAAJaiepsAs)eqo