过滤sql 过滤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)

oracle去重复

oracle去重复 ROW_NUMBER() over(partition by 列名1 order by 列名2)

oracle字段去重

oracle字段去重 以某一个字段去重 oracle字段去重 以某一个字段去重

PM&PL;综合管理能力

PM&PL;综合管理能力

开发ldap入门

LDAP入门

java在线解析xml

java在线解析xml

js导航切换样式

js导航切换样式 Jquery导航切换样式

jquery经验总结

jquery经验总结jquery经验总结

java经典小项目源码

几个java经典小项目源码，jsp,ajax,servlet,stuts,struts2...

平安java面试题

平安java面试题，经典，经典，不容错过！