Oracle数据统计，一张表有以下字段（dwbm,rq,rybm,jbbm）,统计每个单位每年和每月的患病人数。

一张表有以下字段（dwbm,rq,rybm,jbbm）,统计每个单位每年和每月的患病人数。

生病的时候会做一条jbbm不为空的数据，

病好时会做一条jbbm为空的数据，

也会在未生病时做jbbm为空的数据。

例如：dwbm为001，rybm为111的这个人在数据库中共有5条数据，分别是：

201901做了一条jbbm不为空的数据，表示生病了；

201904又做了一条jbbm不为空的数据；

一直到201908才做了一条jbbm为空的数据表示病好了；

并且在201911和202007分别做了2条jbbm为空的数据。

那么这个人的患病情况就是：2019年生病，2020年到目前为止为生病；

201901，201902，201903，201904，201905，201906，201907，201908都生病；

201909，201910，201911，201912，202001，202002，202003，202004，202005，202006，202007未生病。

统计每个单位每年和每月的患病人数。

CREATE TABLE test (
  "dwbm" VARCHAR2(255 BYTE),
  "rq" VARCHAR2(255 BYTE),
  "rybm" VARCHAR2(255 BYTE),
  "jbbm" VARCHAR2(255 BYTE)
)
TABLESPACE "TS_TEST_DATA"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;


INSERT INTO test VALUES ('771623111', '20130131', '7716231111201102180577', '01010000');
INSERT INTO test VALUES ('771623111', '20130130', '7716231111201204252077', '02000000');
INSERT INTO test VALUES ('771623111', '20130130', '7716231111201009176785', '01000000');
INSERT INTO test VALUES ('771623111', '20130130', '7716231111201109160222', '01010000');
INSERT INTO test VALUES ('771623111', '20130130', '7716231111201206292960', '01030000');
INSERT INTO test VALUES ('771623111', '20130130', '7716231111201207043005', '05010000');
INSERT INTO test VALUES ('771623111', '20130130', '7716231111201109210239', '07000000');
INSERT INTO test VALUES ('771623111', '20130129', '7716231111201106070224', '01010000');
INSERT INTO test VALUES ('771623111', '20130129', '7716231111201301010002', '01010000');
INSERT INTO test VALUES ('771623111', '20130128', '7716231111201208103452', '01010000');
INSERT INTO test VALUES ('771623111', '20130128', '7716231111201208103452', '01010000');
INSERT INTO test VALUES ('771623111', '20130128', '7716231111201207183246', '01030000');
INSERT INTO test VALUES ('771623111', '20130205', '7716231111201302050922', '02020000');
INSERT INTO test VALUES ('771623111', '20130205', '7716231111201110250172', '05010000');
INSERT INTO test VALUES ('771623111', '20130205', '7716231111201301290769', '01010000');
INSERT INTO test VALUES ('771623111', '20130205', '7716231111201212134724', '02010000');
INSERT INTO test VALUES ('771623111', '20130205', '7716231111201205182285', '01010000');
INSERT INTO test VALUES ('771623111', '20130205', '7716231111201207143188', '07000000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201208173606', '09000000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201102210600', '02000000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201208043396', '01010000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201302050922', '02020000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201205242345', '07000000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201208253702', '01010000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201208103456', '01030000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201209113838', '08050000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201210124021', '01010000');
INSERT INTO test VALUES ('771623111', '20130206', '7716231111201205302372', '01010000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201203301837', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201206022442', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201210314243', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201206162625', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201203031254', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201208253694', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201207073034', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201012137118', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201205172263', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201209273916', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201201170735', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201203031255', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201209273909', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201206102574', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201206172628', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201106070216', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201208043396', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201206012433', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201207063019', '02000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201301310873', '01000000');
INSERT INTO test VALUES ('771623111', '20130207', '7716231111201206012428', '07000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201205172263', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201209273916', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201203031254', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201206062467', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201203031255', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201207063019', '02000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201209273909', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201201170735', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201208273713', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201210314243', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201203301837', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201206022442', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201206102574', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201206172628', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201206012433', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201208043396', '01000000');
INSERT INTO test VALUES ('771623111', '20130222', '7716231111201012137118', '01000000');
INSERT INTO test VALUES ('771623111', '20130225', '7716231111201208163599', '08040000');
INSERT INTO test VALUES ('771623111', '20130225', '7716231111201112210930', '07000000');
INSERT INTO test VALUES ('771623111', '20130225', '7716231111201208213652', '07000000');
INSERT INTO test VALUES ('771623111', '20130226', '7716231111201209113838', '09000000');
INSERT INTO test VALUES ('771623111', '20130226', '7716231111201210124021', '01030000');
INSERT INTO test VALUES ('771623111', '20130226', '7716231111201211274636', '02000000');
INSERT INTO test VALUES ('771623111', '20130226', '7716231111201209013770', '01010000');
INSERT INTO test VALUES ('771623111', '20130226', '7716231111201111020322', '07000000');
INSERT INTO test VALUES ('771623111', '20130226', '7716231111201203131530', '07000000');
INSERT INTO test VALUES ('771623111', '20130226', '7716231111201209283921', '02000000');
INSERT INTO test VALUES ('771623111', '20130226', '7716231111201206062461', '07000000');
INSERT INTO test VALUES ('771623111', '20130227', '7716231111201301240585', '05000000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201203301837', '01000000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201206022442', '01000000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201211094436', '01000000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201210314243', '01000000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201210174063', '01000000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201206062467', '01000000');
INSERT INTO test VALUES ('771623111', '20121129', '7716231111201201170735', '01000000');
INSERT INTO test VALUES ('771623111', '20121129', '7716231111201208253694', '01000000');
INSERT INTO test VALUES ('771623111', '20121129', '7716231111201205172263', '01000000');
INSERT INTO test VALUES ('771623111', '20121128', '7716231111201211214597', '08000000');
INSERT INTO test VALUES ('771623111', '20121127', '7716231111201209273916', '01010000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201109070076', '07000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201108080764', '05000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201209063792', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201111020324', '05000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201106070224', '01010000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201206072499', '02000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201109190230', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201209273916', '01010000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201211094436', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201211114444', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201210314243', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201210174063', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201205172263', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201205172273', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201206062467', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201203031255', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201208253694', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201201170735', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201208043396', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201206092508', '05000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201206062458', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201203301837', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201206022442', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201209273909', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111200707022992', '07000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201107220649', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201206102574', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201208273713', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201206172628', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201208043396', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201207073034', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201206162625', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201203031254', '01000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201208173608', '01000000');
INSERT INTO test VALUES ('771623111', '20121022', '7716231111201203201726', '01000000');
INSERT INTO test VALUES ('771623111', '20121022', '7716231111201205162252', '01000000');
INSERT INTO test VALUES ('771623111', '20121022', '7716231111201206222743', '05000000');
INSERT INTO test VALUES ('771623111', '20121022', '7716231111201207043012', '07000000');
INSERT INTO test VALUES ('771623111', '20121022', '7716231111201209103805', '07000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201203241788', '05000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201205222332', '05000000');
INSERT INTO test VALUES ('771623111', '20121207', '7716231111201208113472', '07000000');
INSERT INTO test VALUES ('771623111', '20121022', '7716231111201009176785', '01000000');
INSERT INTO test VALUES ('771623111', '20121024', '7716231111201206062466', '02000000');
INSERT INTO test VALUES ('771623111', '20120925', '7716231111201207053014', '05000000');
INSERT INTO test VALUES ('771623111', '20120926', '7716231111201206012433', '01000000');
INSERT INTO test VALUES ('771623111', '20120926', '7716231111201204202033', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201205172263', '01000000');
INSERT INTO test VALUES ('771623111', '20120926', '7716231111201206102574', '01000000');
INSERT INTO test VALUES ('771623111', '20120928', '7716231111201206162626', '07000000');
INSERT INTO test VALUES ('771623111', '20120928', '7716231111201208043396', '05000000');
INSERT INTO test VALUES ('771623111', '20120928', '7716231111201208043396', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201206062467', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201203031255', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201207213274', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201201170735', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201009176785', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201208253694', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201206102574', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201206172628', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201208273713', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201203031254', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201206162625', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201208173608', '01000000');
INSERT INTO test VALUES ('771623111', '20120929', '7716231111201206022442', '01000000');
INSERT INTO test VALUES ('771623111', '20121210', '7716231111201203201726', '01000000');
INSERT INTO test VALUES ('771623111', '20121210', '7716231111201009176785', '01000000');
INSERT INTO test VALUES ('771623111', '20121210', '7716231111201207053014', '05000000');
INSERT INTO test VALUES ('771623111', '20121210', '7716231111201204262089', '01000000');
INSERT INTO test VALUES ('771623111', '20121210', '7716231111201208013374', '01000000');
INSERT INTO test VALUES ('771623111', '20121210', '7716231111201207193258', '01000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201211094436', '01000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201208253695', '01000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201208013371', '01000000');
INSERT INTO test VALUES ('771623111', '20121210', '7716231111201206192636', '07000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201210174063', '01000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201206292960', '01000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201208163604', '01000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201203171641', '01000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201205112206', '07000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201208203636', NULL);
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201206022442', '01000000');
INSERT INTO test VALUES ('771623111', '20121211', '7716231111201206212733', '02000000');
INSERT INTO test VALUES ('771623111', '20121212', '7716231111201209113810', '02000000');
INSERT INTO test VALUES ('771623111', '20121212', '7716231111201208093443', '02000000');
INSERT INTO test VALUES ('771623111', '20121212', '7716231111201209113838', '09000000');
INSERT INTO test VALUES ('771623111', '20121212', '7716231111201208173606', '09000000');
INSERT INTO test VALUES ('771623111', '20121212', '7716231111201208273713', '01000000');
INSERT INTO test VALUES ('771623111', '20121212', '7716231111201212114675', '01000000');
INSERT INTO test VALUES ('771623111', '20121212', '7716231111200707022992', '07000000');
INSERT INTO test VALUES ('771623111', '20121213', '7716231111201209113810', '02000000');
INSERT INTO test VALUES ('771623111', '20121213', '7716231111201206092508', '05000000');
INSERT INTO test VALUES ('771623111', '20121213', '7716231111201203171644', '07000000');
INSERT INTO test VALUES ('771623111', '20121213', '7716231111201102180576', '07000000');
INSERT INTO test VALUES ('771623111', '20121213', '7716231111201203091385', '07000000');
INSERT INTO test VALUES ('771623111', '20121213', '7716231111201207043005', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201109050022', '05000000');
INSERT INTO test VALUES ('771623111', '20121215', '7716231111201111110432', '02000000');
INSERT INTO test VALUES ('771623111', '20121215', '7716231111201208043396', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201205172263', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201211094436', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201205172273', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201206062467', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201203031255', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201208253694', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201201170735', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201209273909', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201206022442', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201206102574', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201210314243', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201208273713', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201203031254', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201206162625', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201207073034', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201208173608', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201206172628', '01000000');
INSERT INTO test VALUES ('771623111', '20121214', '7716231111201208043396', '01000000');
INSERT INTO test VALUES ('771623111', '20121216', '7716231111201212134725', '01000000');
INSERT INTO test VALUES ('771623111', '20121216', '7716231111201106070221', '01000000');
INSERT INTO test VALUES ('771623111', '20121216', '7716231111201204172006', '01000000');
INSERT INTO test VALUES ('771623111', '20121217', '7716231111201210174063', '01000000');
INSERT INTO test VALUES ('771623111', '20121217', '7716231111201206102574', '01000000');
INSERT INTO test VALUES ('771623111', '20121217', '7716231111201009176785', '01000000');
INSERT INTO test VALUES ('771623111', '20121217', '7716231111201212084660', '07000000');
INSERT INTO test VALUES ('771623111', '20121217', '7716231111201212094663', '07000000');
INSERT INTO test VALUES ('771623111', '20121217', '7716231111201208173608', '01000000');
INSERT INTO test VALUES ('771623111', '20121217', '7716231111201206082501', '01000000');
INSERT INTO test VALUES ('771623111', '20121217', '7716231111201205052158', '07000000');
INSERT INTO test VALUES ('771623111', '20121218', '7716231111201211174540', '01000000');
INSERT INTO test VALUES ('771623111', '20121218', '7716231111201202271184', '01000000');
INSERT INTO test VALUES ('771623111', '20121218', '7716231111201209273909', '01000000');
INSERT INTO test VALUES ('771623111', '20121218', '7716231111200707022992', '07000000');
INSERT INTO test VALUES ('771623111', '20121218', '7716231111201211274633', '07000000');
INSERT INTO test VALUES ('771623111', '20121218', '7716231111201212184774', '02000000');
INSERT INTO test VALUES ('771623111', '20130319', '7716231111201201170735', '01030000');
INSERT INTO test VALUES ('771623111', '20130319', '7716231111201301120285', NULL);
INSERT INTO test VALUES ('771623111', '20130319', '7716231111201208043396', '05010000');
INSERT INTO test VALUES ('771623111', '20130319', '7716231111201212084661', '07030000');
INSERT INTO test VALUES ('771623111', '20130319', '7716231111201208263705', '01010000');
INSERT INTO test VALUES ('771623111', '20130319', '7716231111201302161207', '05010000');
INSERT INTO test VALUES ('771623111', '20130319', '7716231111201203031255', '05010000');
INSERT INTO test VALUES ('771623111', '20130319', '7716231111201207063019', '02000000');
INSERT INTO test VALUES ('771623111', '20130319', '7716231111201207043005', NULL);
INSERT INTO test VALUES ('771623111', '20130320', '7716231111201207073034', '01000000');
INSERT INTO test VALUES ('771623111', '20130320', '7716231111201208043396', '07030000');
INSERT INTO test VALUES ('771623111', '20130320', '7716231111201206012433', '01000000');
INSERT INTO test VALUES ('771623111', '20130320', '7716231111201211164509', '01010000');
INSERT INTO test VALUES ('771623111', '20130321', '7716231111201112140856', '05010000');
INSERT INTO test VALUES ('771623111', '20130321', '7716231111201109160218', NULL);
INSERT INTO test VALUES ('771623111', '20130321', '7716231111201206302967', NULL);
INSERT INTO test VALUES ('771623111', '20130321', '7716231111201203301837', '01000000');
INSERT INTO test VALUES ('771623111', '20130321', '7716231111201212295026', NULL);
INSERT INTO test VALUES ('771623111', '20130321', '7716231111201111160493', NULL);
INSERT INTO test VALUES ('771623111', '20130321', '7716231111201303101587', '02020000');
INSERT INTO test VALUES ('771623111', '20130322', '7716231111201208043396', '01000000');
INSERT INTO test VALUES ('771623111', '20130322', '7716231111201212054656', '05010000');
INSERT INTO test VALUES ('771623111', '20130322', '7716231111201205172263', '01000000');
INSERT INTO test VALUES ('771623111', '20130327', '7716231111201209243882', NULL);
INSERT INTO test VALUES ('771623111', '20130327', '7716231111201203171645', '07030000');
INSERT INTO test VALUES ('771623111', '20130327', '7716231111201206062460', '01010000');
INSERT INTO test VALUES ('771623111', '20130327', '7716231111201208113467', '01010000');
INSERT INTO test VALUES ('771623111', '20130327', '7716231111201208043396', '05010000');
INSERT INTO test VALUES ('771623111', '20130328', '7716231111201111020324', '05010000');
INSERT INTO test VALUES ('771623111', '20130328', '7716231111201208043398', '01010000');
INSERT INTO test VALUES ('771623111', '20130328', '7716231111201206012433', '06000000');
INSERT INTO test VALUES ('771623111', '20130329', '7716231111201302081205', '09000000');
INSERT INTO test VALUES ('771623111', '20130329', '7716231111201208163599', '08040000');
INSERT INTO test VALUES ('771623111', '20130329', '7716231111201301180422', '01030000');
INSERT INTO test VALUES ('771623111', '20130329', '7716231111201208173606', '09000000');
INSERT INTO test VALUES ('771623111', '20130329', '7716231111201209113838', '09000000');
INSERT INTO test VALUES ('771623111', '20130330', '7716231111201207143188', NULL);
INSERT INTO test VALUES ('771623111', '20130330', '7716231111201206012431', NULL);
INSERT INTO test VALUES ('771623111', '20130330', '7716231111201102180577', '01010000');
INSERT INTO test VALUES ('771623111', '20130330', '7716231111201302201253', '01030300');
INSERT INTO test VALUES ('771623111', '20130330', '7716231111201301240584', '01030000');
INSERT INTO test VALUES ('771623111', '20130330', '7716231111201206062466', NULL);
INSERT INTO test VALUES ('771623111', '20130330', '7716231111201208213652', '05010000');
INSERT INTO test VALUES ('771623111', '20130330', '7716231111201303141679', NULL);
INSERT INTO test VALUES ('771623111', '20130329', '7716231111201303211880', '01000000');
INSERT INTO test VALUES ('771623111', '20130329', '7716231111201109210239', '07030000');
INSERT INTO test VALUES ('771623111', '20130329', '7716231111201204262088', NULL);
INSERT INTO test VALUES ('771623111', '20130331', '7716231111201205292368', NULL);
INSERT INTO test VALUES ('771623111', '20130331', '7716231111201303101592', NULL);
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201009176785', '01000000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201205162252', '01000000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201204252077', '01030000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201109070076', '07030000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201211304646', NULL);
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201207313366', NULL);
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201301190504', '05010000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201203091383', NULL);
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201203301837', '01000000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201111020322', '01010000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201206062460', '07030000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201207233303', '07030000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201205242345', '07030000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201206262869', NULL);
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201303231921', NULL);
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201303241922', '07030000');
INSERT INTO test VALUES ('771623111', '20130401', '7716231111201206062465', '07030000');
INSERT INTO test VALUES ('771623111', '20130402', '7716231111201212134725', '08050000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201207113102', '05010000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201209113838', '09000000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201208173606', '09000000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201302081205', '09000000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201208163599', '08040000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201109210238', '01010000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201206062459', '01010000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201210013968', NULL);
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201212264920', NULL);
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201301180430', '08050000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201212174767', '01030000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201301150331', NULL);
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201212134724', NULL);
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201301110271', '05010000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201208163604', '05010000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201212124704', '05010000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201202271184', '01030000');
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201303151682', NULL);
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201303121595', NULL);
INSERT INTO test VALUES ('771623111', '20130403', '7716231111201112140856', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201208043396', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201208013373', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201205112204', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201203061317', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201208213652', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201111020324', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201207143188', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201301160333', '01030200');
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201304052273', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201302201253', '01030000');
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201301240584', NULL);
INSERT INTO test VALUES ('771623111', '20130405', '7716231111201209273916', NULL);
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201303061560', NULL);
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201303151682', '01030000');
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201209033778', NULL);
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201205292368', NULL);
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201208213652', '01030000');
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201208013373', NULL);
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201203071347', NULL);
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201212184775', '01010000');
INSERT INTO test VALUES ('771623111', '20130408', '7716231111201210264144', NULL);
INSERT INTO test VALUES ('771623111', '20130408', '7716231111201208173606', '09000000');
INSERT INTO test VALUES ('771623111', '20130408', '7716231111201209113838', '09000000');
INSERT INTO test VALUES ('771623111', '20130408', '7716231111201302081205', '09000000');
INSERT INTO test VALUES ('771623111', '20130408', '7716231111201208163599', '08040000');
INSERT INTO test VALUES ('771623111', '20130408', '7716231111201206062467', NULL);
INSERT INTO test VALUES ('771623111', '20130408', '7716231111201209273912', '01030000');
INSERT INTO test VALUES ('771623111', '20130408', '7716231111201303221887', NULL);
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201206062459', '05000000');
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201203301837', '01000000');
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201304042233', '01030000');
INSERT INTO test VALUES ('771623111', '20130407', '7716231111201203091383', NULL);
INSERT INTO test VALUES ('771623111', '20130227', '7716231111201208213652', '07000000');
INSERT INTO test VALUES ('771623111', '20130227', '7716231111201209283921', '02000000');
INSERT INTO test VALUES ('771623111', '20130227', '7716231111201208173606', '09000000');
INSERT INTO test VALUES ('771623111', '20130227', '7716231111201209113838', '09000000');
INSERT INTO test VALUES ('771623111', '20130227', '7716231111201302081205', '09000000');
INSERT INTO test VALUES ('771623111', '20130227', '7716231111201206092508', '01010000');
INSERT INTO test VALUES ('771623111', '20130227', '7716231111201208043396', '01010000');
INSERT INTO test VALUES ('771623111', '20130227', '7716231111201212214831', '07000000');
INSERT INTO test VALUES ('771623111', '20130228', '7716231111201301160333', '07010000');
INSERT INTO test VALUES ('771623111', '20130228', '7716231111201208163599', '08000000');
INSERT INTO test VALUES ('771623111', '20130228', '7716231111201301010002', '07000000');
INSERT INTO test VALUES ('771623111', '20130228', '7716231111201205032128', '05010000');
INSERT INTO test VALUES ('771623111', '20130228', '7716231111201108080764', '05010000');
INSERT INTO test VALUES ('771623111', '20130228', '7716231111201207143188', '01030000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201203131530', '05010000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201111030389', '07000000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201206202698', '01010000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201207193256', '07030000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201203091385', '07030000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201202271184', '01030000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201203191722', '07030000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201211144493', '01010000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201207243313', '07030000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201301180424', '07030000');
INSERT INTO test VALUES ('771623111', '20130301', '7716231111201302191251', '07030000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201009176785', '01000000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201205162252', '01000000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201206302967', '07000000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201209063789', '02000000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201207042999', '01030000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201111020323', '01030000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201210284231', '01000000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201301110271', '05010000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201302261393', '01030000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201209283921', '05010000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201212184775', '01030000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201208173606', '09000000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201209113838', '09000000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201208103450', NULL);
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201205242345', NULL);
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201302081205', '09000000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201208163599', '08040000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201208043396', '01010000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201112140856', NULL);
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201109210238', '07030000');
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201302231383', NULL);
INSERT INTO test VALUES ('771623111', '20130304', '7716231111201302261415', '01010000');
INSERT INTO test VALUES ('771623111', '20130305', '7716231111201201170735', '01000000');
INSERT INTO test VALUES ('771623111', '20130305', '7716231111201206092508', '07000000');
INSERT INTO test VALUES ('771623111', '20130305', '7716231111201208043396', '01000000');
INSERT INTO test VALUES ('771623111', '20130305', '7716231111201108090807', '08000000');
INSERT INTO test VALUES ('771623111', '20130305', '7716231111200705302919', '01010000');
INSERT INTO test VALUES ('771623111', '20130305', '7716231111201302201253', '01000000');
INSERT INTO test VALUES ('771623111', '20130305', '7716231111201203091383', '07000000');
INSERT INTO test VALUES ('771623111', '20120810', '7716231111201202151012', '07000000');
INSERT INTO test VALUES ('771623111', '20120814', '7716231111201010256915', '01010000');
INSERT INTO test VALUES ('771623111', '20120813', '7716231111201204222054', '02000000');
INSERT INTO test VALUES ('771623111', '20120821', '7716231111201202261180', '07000000');
INSERT INTO test VALUES ('771623111', '20120822', '7716231111201208023384', '05000000');
INSERT INTO test VALUES ('771623111', '20120907', '7716231111201204232055', '02010000');
INSERT INTO test VALUES ('771623111', '20120914', '7716231111201206022442', '01000000');
INSERT INTO test VALUES ('771623111', '20120920', '7716231111201208163603', '05010000');
INSERT INTO test VALUES ('771623111', '20120926', '7716231111201203081376', '01040000');
INSERT INTO test VALUES ('771623111', '20121009', '7716231111201202030887', '01010000');
INSERT INTO test VALUES ('771623111', '20121005', '7716231111201206102574', '02010000');
INSERT INTO test VALUES ('771623111', '20121028', '7716231111201203011206', '01000000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201209113838', '09000000');
INSERT INTO test VALUES ('771623111', '20121204', '7716231111201209113838', '09000000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201208163599', '08000000');
INSERT INTO test VALUES ('771623111', '20121204', '7716231111201208163599', '08000000');
INSERT INTO test VALUES ('771623111', '20121204', '7716231111201204141986', '05000000');
INSERT INTO test VALUES ('771623111', '20121203', '7716231111201203201726', '01000000');
INSERT INTO test VALUES ('771623111', '20121203', '7716231111201205162252', '01000000');
INSERT INTO test VALUES ('771623111', '20121203', '7716231111201009176785', '01000000');
INSERT INTO test VALUES ('771623111', '20121203', '7716231111201204192030', NULL);
INSERT INTO test VALUES ('771623111', '20121129', '7716231111201208253694', '01000000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201208013374', '01000000');
INSERT INTO test VALUES ('771623111', '20121129', '7716231111201207153192', '02000000');
INSERT INTO test VALUES ('771623111', '20121129', '7716231111201208283715', '05000000');
INSERT INTO test VALUES ('771623111', '20121129', '7716231111201209213877', '05000000');
INSERT INTO test VALUES ('771623111', '20121129', '7716231111201207273330', '02000000');
INSERT INTO test VALUES ('771623111', '20121128', '7716231111201208163604', '07000000');
INSERT INTO test VALUES ('771623111', '20121128', '7716231111201201160730', '07000000');
INSERT INTO test VALUES ('771623111', '20121128', '7716231111201109160221', '05000000');
INSERT INTO test VALUES ('771623111', '20121128', '7716231111201209283921', '01000000');
INSERT INTO test VALUES ('771623111', '20121127', '7716231111201208283716', '01000000');
INSERT INTO test VALUES ('771623111', '20121127', '7716231111201206162627', '07000000');
INSERT INTO test VALUES ('841123111', '20160701', '8411231111201506170022', NULL);
INSERT INTO test VALUES ('841123111', '20160801', '8411231111201506170021', NULL);
INSERT INTO test VALUES ('841123111', '20160801', '8411231111201506170021', NULL);
INSERT INTO test VALUES ('841123111', '20160801', '8411231111201506170022', NULL);
INSERT INTO test VALUES ('771623111', '20121127', '7716231111201206122590', '01000000');
INSERT INTO test VALUES ('771623111', '20121127', '7716231111201207213274', '01000000');
INSERT INTO test VALUES ('771623111', '20121127', '7716231111201206032443', '01000000');
INSERT INTO test VALUES ('771623111', '20121126', '7716231111201203201726', '01000000');
INSERT INTO test VALUES ('771623111', '20121126', '7716231111201009176785', '01000000');
INSERT INTO test VALUES ('771623111', '20121119', '7716231111201206012432', '01000000');
INSERT INTO test VALUES ('771623111', '20121119', '7716231111201206212731', '07000000');
INSERT INTO test VALUES ('771623111', '20121119', '7716231111201205142210', '01000000');
INSERT INTO test VALUES ('771623111', '20121118', '7716231111201210134030', '02000000');
INSERT INTO test VALUES ('771623111', '20121119', '7716231111201203201726', '01000000');
INSERT INTO test VALUES ('771623111', '20121119', '7716231111201205112205', '07000000');
INSERT INTO test VALUES ('771623111', '20121119', '7716231111201206062466', '07020000');
INSERT INTO test VALUES ('771623111', '20121119', '7716231111201209243882', '01000000');
INSERT INTO test VALUES ('771623111', '20121119', '7716231111201207053014', '05010000');
INSERT INTO test VALUES ('771623111', '20121119', '7716231111201207173237', '05010000');
INSERT INTO test VALUES ('771623111', '20121116', '7716231111201208263705', '01010000');
INSERT INTO test VALUES ('771623111', '20121116', '7716231111201009176785', '01020000');
INSERT INTO test VALUES ('771623111', '20121115', '7716231111201208103456', '01030000');
INSERT INTO test VALUES ('771623111', '20121115', '7716231111201102210600', '07039900');
INSERT INTO test VALUES ('771623111', '20121115', '7716231111201209073795', NULL);
INSERT INTO test VALUES ('771623111', '20121115', '7716231111201206132594', '01000000');
INSERT INTO test VALUES ('771623111', '20121114', '7716231111201206282907', '01030202');
INSERT INTO test VALUES ('771623111', '20121114', '7716231111201208163600', '01010000');
INSERT INTO test VALUES ('771623111', '20121114', '7716231111201206032443', '01010000');
INSERT INTO test VALUES ('771623111', '20121113', '7716231111200810254278', '01010000');
INSERT INTO test VALUES ('771623111', '20121205', '7716231111201203301836', '01040000');
INSERT INTO test VALUES ('771623111', '20121205', '7716231111201211024271', '07000000');
INSERT INTO test VALUES ('771623111', '20121205', '7716231111201106070224', '07030100');
INSERT INTO test VALUES ('841123111', '20150518', '8411231111201411050116', NULL);
INSERT INTO test VALUES ('841123111', '20150526', '8411231111201210170098', NULL);
INSERT INTO test VALUES ('841123111', '20150526', '8411231111201306070027', NULL);
INSERT INTO test VALUES ('841123111', '20150508', '8411231111201504200008', NULL);
INSERT INTO test VALUES ('841123111', '20150526', '8411231111201306070027', NULL);
INSERT INTO test VALUES ('841123111', '20150526', '8411231111201306070027', NULL);
INSERT INTO test VALUES ('841123111', '20150526', '8411231111201306070027', NULL);
INSERT INTO test VALUES ('841123111', '20140306', '8411231111201403050044', NULL);
INSERT INTO test VALUES ('841123111', '20140312', '8411231111201402280029', '06060000');
INSERT INTO test VALUES ('432223110', '20140319', '4322231100201403130001', '06090300');
INSERT INTO test VALUES ('821124121', '20140321', '8211241211201403200002', NULL);
INSERT INTO test VALUES ('832123121', '20140314', '8321231211201403130001', NULL);
INSERT INTO test VALUES ('841123141', '20140429', '8411231411201310140041', NULL);
INSERT INTO test VALUES ('841123111', '20120413', '8411231111201203140049', '01000000');
INSERT INTO test VALUES ('841123111', '20120416', '8411231111201203140049', NULL);
INSERT INTO test VALUES ('841123111', '20120423', '8411231111201204230059', '01000000');
INSERT INTO test VALUES ('841123111', '20120413', '8411231111201201150016', '01000000');
INSERT INTO test VALUES ('841123111', '20120428', '8411231111201201160019', '05020100');
INSERT INTO test VALUES ('841123111', '20120413', '8411231111201203140049', NULL);
INSERT INTO test VALUES ('841123111', '20120428', '8411231111201203060038', '05020700');
INSERT INTO test VALUES ('841123111', '20120112', '8411231111201201120001', '01010000');
INSERT INTO test VALUES ('841123121', '20120119', '8411231211201201130003', '01010000');
INSERT INTO test VALUES ('841123111', '20120225', '8411231111201201160018', NULL);
INSERT INTO test VALUES ('831123111', '20120201', '8311231111201201120003', '01010201');
INSERT INTO test VALUES ('841123111', '20120229', '8411231111201201160017', '01010102');
INSERT INTO test VALUES ('841123111', '20120306', '8411231111201201160017', '05010500');
INSERT INTO test VALUES ('841123121', '20120416', '8411231211201204160028', '03020602');
INSERT INTO test VALUES ('841123111', '20120525', '8411231111201201160018', NULL);
INSERT INTO test VALUES ('841123131', '20120604', '8411231311201202100005', NULL);
INSERT INTO test VALUES ('841123111', '20120613', '8411231111201201160018', '03000000');
INSERT INTO test VALUES ('841123111', '20131016', '8411231111201203080041', NULL);
INSERT INTO test VALUES ('841123111', '20131217', '8411231111201203120045', NULL);
INSERT INTO test VALUES ('841123111', '20131217', '8411231111201208230031', NULL);
INSERT INTO test VALUES ('841123111', '20120608', '8411231111201201160018', NULL);
INSERT INTO test VALUES ('841123111', '20120628', '8411231111201201160018', NULL);
INSERT INTO test VALUES ('841123111', '20120628', '8411231111201201160018', NULL);
INSERT INTO test VALUES ('841123111', '20120601', '8411231111201201160018', NULL);
INSERT INTO test VALUES ('841123111', '20120613', '8411231111201201160018', '10000000');
INSERT INTO test VALUES ('841123111', '20130707', '8411231111201303200016', NULL);
INSERT INTO test VALUES ('841123111', '20130718', '8411231111201307180039', '03010300');
INSERT INTO test VALUES ('841123111', '20120815', '8411231111201205220001', NULL);
INSERT INTO test VALUES ('841123141', '20131009', '8411231411201310090038', NULL);
INSERT INTO test VALUES ('841123111', '20131217', '8411231111201203120045', NULL);
INSERT INTO test VALUES ('841123111', '20120613', '8411231111201201160018', '05000000');
INSERT INTO test VALUES ('831123121', '20121012', '8311231211201204180016', '08000000');
INSERT INTO test VALUES ('821123012', '20130111', '8211230122201301110001', NULL);
INSERT INTO test VALUES ('841123141', '20131007', '8411231411201309260032', '11040200');
INSERT INTO test VALUES ('841123111', '20140311', '8411231111201306070031', NULL);
INSERT INTO test VALUES ('841123111', '20140312', '8411231111201402280029', NULL);
INSERT INTO test VALUES ('841123171', '20140610', '8411231111201406030079', NULL);
INSERT INTO test VALUES ('841123111', '20140922', '8411231111201408220101', '04010100');
INSERT INTO test VALUES ('841123121', '20140212', '8411231211201202070018', NULL);
INSERT INTO test VALUES ('841123111', '20140312', '8411231111201203130046', NULL);
INSERT INTO test VALUES ('431233110', '20140318', '4312331100201403180002', NULL);
INSERT INTO test VALUES ('822223121', '20140318', '8222231211201403180003', NULL);
INSERT INTO test VALUES ('841123171', '20140523', '8411231111201402140016', '07020000');
INSERT INTO test VALUES ('841123111', '20140312', '8411231111201402280029', NULL);
INSERT INTO test VALUES ('432223110', '20140314', '4322231100201403130002', NULL);
INSERT INTO test VALUES ('841123111', '20150512', '8411231111201501220004', NULL);
INSERT INTO test VALUES ('431233110', '20141229', '4312331100201403180004', '11010500');
INSERT INTO test VALUES ('841123111', '20150526', '8411231111201404210064', NULL);
INSERT INTO test VALUES ('431233110', '20160520', '4312331100201604190001', NULL);
INSERT INTO test VALUES ('431233110', '20160601', '4312331100201410100024', NULL);
INSERT INTO test VALUES ('771623111', '20121205', '7716231111201106080012', '01040000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111201109160221', '01030000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111201208253694', '01010000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111201203101390', '01010000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111201102180579', '01030000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111201204021862', '01000000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111200810254278', '01010000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111201203201726', '01020000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111201009176785', '01020000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111201109070076', '07030000');
INSERT INTO test VALUES ('771623111', '20121112', '7716231111201207103091', '05010000');
INSERT INTO test VALUES ('771623111', '20121109', '7716231111201205092176', '01010000');
INSERT INTO test VALUES ('771623111', '20121109', '7716231111201208063405', '01010000');
INSERT INTO test VALUES ('771623111', '20121109', '7716231111201203201726', '01020000');
INSERT INTO test VALUES ('771623111', '20121109', '7716231111201205162252', '01020000');
INSERT INTO test VALUES ('771623111', '20121109', '7716231111201202251174', '05010000');
INSERT INTO test VALUES ('771623111', '20121109', '7716231111201206032443', '01010000');
INSERT INTO test VALUES ('771623111', '20121109', '7716231111201208283726', '07000000');
INSERT INTO test VALUES ('771623111', '20121109', '7716231111201209053783', '05000000');
INSERT INTO test VALUES ('771623111', '20121201', '7716231111201206062459', '01030000');
INSERT INTO test VALUES ('771623111', '20121201', '7716231111201204252079', '02020000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201208253694', '01080700');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201209273909', '01020000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201209273916', '01010000');
INSERT INTO test VALUES ('771623111', '20121130', '7716231111201206012433', '01020000');
INSERT INTO test

哪个是单位字段。。。

dwbm

我看你表里面的时间包含天数吧。

按年：

SELECT

*

FROM

(

SELECT

A ."dwbm",

A ."rq" "year",

SUM (A ."COUNT") "sickCount"

FROM

(

SELECT

"dwbm",

"SUBSTR" ("rq", 0, 4) "rq",

"rybm",

COUNT (*) COUNT

FROM

"test"

WHERE

"jbbm" IS NOT NULL

GROUP BY

"dwbm",

"rq",

"rybm"

) A

GROUP BY

A ."dwbm",

A ."rq"

) T

ORDER BY

T ."dwbm",

T ."year"

按月：

SELECT

*

FROM

(

SELECT

A ."dwbm",

A ."rq" "month",

SUM (A ."COUNT") "sickCount"

FROM

(

SELECT

"dwbm",

"SUBSTR" ("rq", 0, 6) "rq",

"rybm",

COUNT (*) COUNT

FROM

"test"

WHERE

"jbbm" IS NOT NULL

GROUP BY

"dwbm",

"rq",

"rybm"

) A

GROUP BY

A ."dwbm",

A ."rq"

) T

ORDER BY

T ."dwbm",

T ."month"

不晓得对不对

mysql的写法：

select dwbm,DATE_FORMAT(rq,'%Y%m') month,SUM(flag) "生病人数" from (

   select dwbm,rq,rybm,jbbm,IF(jbbm is NULL,0,1) flag from test where jbbm is not NULL

) aa GROUP BY dwbm,month

oracle的写法，不太会。你看看能不能自己修改里面的一些函数。

select dwbm,to_date(rq,''yyyyMM') month,SUM(flag) "生病人数" from (

   select dwbm,rq,rybm,jbbm,nvl2(jbbm,1,0) flag from test where jbbm is not NULL

) aa GROUP BY dwbm,month

oracle的写法：

select dwbm,to_char(rq,''yyyyMM') month,SUM(flag) "生病人数" from (

   select dwbm,rq,rybm,jbbm,nvl2(jbbm,1,0) flag from test where jbbm is not NULL

) aa GROUP BY dwbm,month

我只想说你们设计师很牛逼

例如：dwbm为001，rybm为111的这个人在数据库中共有5条数据，分别是：

201901做了一条jbbm不为空的数据，表示生病了；

201904又做了一条jbbm不为空的数据；

一直到201908才做了一条jbbm为空的数据表示病好了；

并且在201911和202007分别做了2条jbbm为空的数据。

那么这个人的患病情况就是：2019年生病，2020年到目前为止为生病；

201901，201902，201903，201904，201905，201906，201907，201908都生病；

201909，201910，201911，201912，202001，202002，202003，202004，202005，202006，202007未生病。

你们没有把生病到病好中间的月份算上

而且jbbm为null的也不都是未生病的情况。再仔细看一下例子里面的

你要统计的是按月统计，你的数据确实按天

一个月中既有生病又有未生病，算生病还是未生病？

生病与否用jbbm是否为空进行判断，jbbm不为空表示生病了，一直到（以月份排序）有一条jbbm为空的数据的时候这个人的病才好，然后一直到一条jbbm不为空的数据时，这个人又病了 就这样以此类推嘛 我建议这个逻辑在代码里面做，非常简单

加我QQ3461896724我帮你看看

一个月中既有生病又有未生病的，算生病

所以我那样写没啥问题啊，只是查询出来的全是生病的情况。

你需要统计每个单位每年和每月的患病人数。

没有患病的月份就没必要显示了。本身查询的结果里面不含未生病的月份也就是没有患病的人了

后面这个是你的sql查询的结果，201102是5个人，这5个人在201103并没有做jbbm为空（表示病好）的记录，那么这5个人应该记录在201103以及后面的月份中，201103新增的这3个也并不是在之前就生病的人，所以201103这个月就应该是8个。同样的201104就应该是11个。

这个。。还是在代码中好判断，你这个有点复杂了

就是在sql中不太好判断。

他说的这个逻辑是正确的

是啊，这个都知道。在sql里面就不好做了

为什么你一定要sql呢？代码里面处理很方便啊，如果你一定要用sql，请听我的，写个函数吧

写函数，比如说呢，用递归吗？

我不知道你为什么非要用sql，还是强烈建议你用程序跑，如果你非要用sql，你加我QQ 1049545450 我有个解决方案雏形

你这个需求是典型的分析数据，用窗口函数，普通连接写的sql不仅不好写，而且容易出错，不好维护，性能很差。

能举例说明一下吗？我用了几个开窗函数都试了试，最接近的是sum()over()，但是还是无法正确计算出来