文件名称：过滤sql 过滤sql
文件大小：3KB
文件格式：SQL
更新时间：2016-01-09 18:17:38
过滤sql
----105 select * from ( select a.* from computer a where a.item_attibute='B' AND a.status in('1002') AND a.check_result='F' and (select count(*) from computer aa where aa.item_attibute='B' AND aa.check_result='F' AND aa.term_id = a.term_id) = (select (select count(*) sumy from computer a1 where a1.check_result='F' AND a1.detail_result='Y' and a1.item_attibute='B' and a1.term_id = a.term_id)+ (select count(*) sumn from computer a2 where a2.check_result='F' AND a2.detail_result='N' and a2.item_attibute='B' and a2.status in('1002') and a2.term_id = a.term_id) from dual) ) ------------------- a.item_attibute='B' AND a.status in('1002') AND a.check_result='F' and (select count(*) from computer aa where aa.item_attibute='B' AND aa.check_result='F' AND aa.term_id = a.term_id) = (select (select count(*) sumy from computer a1 where a1.check_result='F' AND a1.detail_result='Y' and a1.item_attibute='B' and a1.term_id = a.term_id)+ (select count(*) sumn from computer a2 where a2.check_result='F' AND a2.detail_result='N' and a2.item_attibute='B' and a2.status in('1002') and a2.term_id = a.term_id) from dual)