文档介绍:数据集名称:阿城参保人数select(selectcount(aac001)='1')+(selectcount(aac001)='1')fromdual数据集编号:002数据集名称:阿城工资额selectROUND(SUM(DECODE(SUBSTR(,1,1),'1',DECODE(,'120',,'142',,'140',,0),0))/200,2),--集体企业ROUND(SUM(DECODE(SUBSTR(,1,1),'1',DECODE(SUBSTR(,1,1),'2',,'3',,0),0))/200,2),--三资ROUND(SUM(DECODE(SUBSTR(,1,1),'1',DECODE(SUBSTR(,1,2),'17',,'3',,0),0))/200,2),--私营ROUND(SUM(DECODE(SUBSTR(,1,1),'2',,0))/200,2)--,=>=<=操作所属结束结算期数据集编号:003数据集名称:阿城国有企业覆盖情况select(SELECTSUM(DECODE(SUBSTR(AAB019,1,1),'1',DECODE(AAB020,'100',1,'110',1,'141',1,'143',1,'151',1,0),0))--,(SELECT*='1')=)+(SELECTSUM(DECODE(SUBSTR(,1,1),'1',DECODE(,'100',1,'110',1,'141',1,'143',1,'151',1,0),0))--,(SELECT*=统计当前月)=)fromdual数据集编号:004数据集名称:阿城集体企业覆盖情况select(SELECTSUM(DECODE(SUBSTR(AAB019,1,1),'1',DECODE(AAB020,'120',1,'142',1,'140',1,0),0))--,(SELECT*='1')=)+(SELECTSUM(DECODE(SUBSTR(,1,1),'1',DECODE(,'120',1,'142',1,'140',1,0),0))--,(SELECT*=[统计当前月])=)fromdual数据集编号:005数据集名称:阿城三资企业覆盖情况select(SELECTSUM(DECODE(SUBSTR(AAB019,1,1),'1',DECODE(SUBSTR(AAB020,1,1),'2',1,'3',1,0),0))--,(SELECT*='1')=)+(SELECTSUM(DECODE(SUBSTR(,1,1),'1',DECODE(SUBSTR(,1,1),'2',1,'3',1,0),0))--,(SELECT*=统计当前月)=)fromdual数据集编号:006数据集名称:阿城事业单位覆盖