文档介绍：专业资料专业资料参考首选数据集编号: 001 数据集名称:阿城参保人数 select ( select count (aac001) from where aac031 = '1' ) +( select count (aac001) from where ajc340 = '1' ) from dual 数据集编号: 002 数据集名称:阿城工资额 select ROUND( 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) -- 事业 from a, b 专业资料专业资料参考首选 where = and >= 操作所属开始结算期 and <= 操作所属结束结算期数据集编号: 003 数据集名称:阿城国有企业覆盖情况 select ( SELECT SUM (DECODE(SUBSTR(AAB019, 1,1 ), '1' , DECODE(AAB020, '100' ,1, '110' ,1, '141' ,1, '143' ,1, '151' ,1,0 ), 0 )) -- 国有企业 From b, ( SELECT * FROM WHERE AAC031 = '1' )a Where = ) + ( SELECT SUM (DECODE(SUBSTR(, 1,1 ), '1' , DECODE(, '100' ,1, '110' ,1, '141' ,1, '143' ,1, '151' ,1,0 ), 0 )) -- 国有企业 From b, ( SELECT * FROM where aae002 = 统计当前月) a Where = ) from dual 专业资料专业资料参考首选数据集编号: 004 数据集名称:阿城集体企业覆盖情况 select (SELECT SUM(DECODE(SUBSTR(AAB019, 1, 1), '1', DECODE(AAB020, '120', 1, '142', 1, '140', 1, 0), 0)) -- 集体企业 From b, (SELECT * FROM WHERE AAC031 = '1') a Where = )+(SELECT SUM(DECODE(SUBSTR(, 1, 1), '1', DECODE(, '120', 1, '142', 1, '140', 1, 0), 0)) -- 集体企业 From b, (SELECT * FROM where aae002=[ 统计当前月])a Where = ) from dual 数据集编号: 005 数据集名称:阿城三资企业覆盖情况 select ( SELECT SUM (DECODE(SUBSTR(AAB019, 1,1 ), '1' , DECODE(