问题详情
描述
生产查询脚本示例:
SELECT * FROM prpm_case_info WHERE insure_com_branch_code NOT in (
'00000000',
'10000000',
'11000000',
'12000000',
'13000000',
'20000000',
'21000000',
'22000000',
'30000000',
'50000000',
'60000000',
'61000000',
'62000000',
'63000000',
'64000000'
)
AND report_time<'2021-09-26'
以上SQL导致机构编码为00020000的没有统计进去