select distinct mbrid,dos from fo05 where
(dx1 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx2 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx3 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx4 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx5 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx6 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx7 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx8 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx9 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843'))
and ((((cpt between '99201' and '99205') or (cpt between '99211' and '99215') or (cpt between '99241' and '99245') or (cpt between '99271' and '99275')
or (cpt between '99301' and '99313') or (cpt between '99315' and '99316') or (cpt between '99318' and '99337') or (cpt between '99341' and '99350')
or (cpt between '99354' and '99355') or (cpt between '99381' and '99387') or (cpt between '99391' and '99397') or (cpt between '99401' and '99429')
or (cpt= '99450') or (cpt between '99455' and '99456'))
or ((cpt1 between '99201' and '99205') or (cpt1 between '99211' and '99215') or (cpt1 between '99241' and '99245') or (cpt1 between '99271' and '99275')
or (cpt1 between '99301' and '99313') or (cpt1 between '99315' and '99316') or (cpt1 between '99318' and '99337') or (cpt1 between '99341' and '99350')
or (cpt1 between '99354' and '99355') or (cpt1 between '99381' and '99387') or (cpt1 between '99391' and '99397') or (cpt1 between '99401' and '99429')
or (cpt1= '99450') or (cpt1 between '99455' and '99456'))
or ((cpt2 between '99201' and '99205') or (cpt2 between '99211' and '99215') or (cpt2 between '99241' and '99245') or (cpt2 between '99271' and '99275')
or (cpt2 between '99301' and '99313') or (cpt2 between '99315' and '99316') or (cpt2 between '99318' and '99337') or (cpt2 between '99341' and '99350')
or (cpt2 between '99354' and '99355') or (cpt2 between '99381' and '99387') or (cpt2 between '99391' and '99397') or (cpt2 between '99401' and '99429')
or (cpt2= '99450') or (cpt2 between '99455' and '99456'))
or ((cpt3 between '99201' and '99205') or (cpt3 between '99211' and '99215') or (cpt3 between '99241' and '99245') or (cpt3 between '99271' and '99275')
or (cpt3 between '99301' and '99313') or (cpt3 between '99315' and '99316') or (cpt3 between '99318' and '99337') or (cpt3 between '99341' and '99350')
or (cpt3 between '99354' and '99355') or (cpt3 between '99381' and '99387') or (cpt3 between '99391' and '99397') or (cpt3 between '99401' and '99429')
or (cpt3= '99450') or (cpt3 between '99455' and '99456'))
or ((cpt4 between '99201' and '99205') or (cpt4 between '99211' and '99215') or (cpt4 between '99241' and '99245') or (cpt4 between '99271' and '99275')
or (cpt4 between '99301' and '99313') or (cpt4 between '99315' and '99316') or (cpt4 between '99318' and '99337') or (cpt4 between '99341' and '99350')
or (cpt4 between '99354' and '99355') or (cpt4 between '99381' and '99387') or (cpt4 between '99391' and '99397') or (cpt4 between '99401' and '99429')
or (cpt4= '99450') or (cpt4 between '99455' and '99456'))
or ((cpt5 between '99201' and '99205') or (cpt5 between '99211' and '99215') or (cpt5 between '99241' and '99245') or (cpt5 between '99271' and '99275')
or (cpt5 between '99301' and '99313') or (cpt5 between '99315' and '99316') or (cpt5 between '99318' and '99337') or (cpt5 between '99341' and '99350')
or (cpt5 between '99354' and '99355') or (cpt5 between '99381' and '99387') or (cpt5 between '99391' and '99397') or (cpt5 between '99401' and '99429')
or (cpt5= '99450') or (cpt5 between '99455' and '99456'))
or ((cpt6 between '99201' and '99205') or (cpt6 between '99211' and '99215') or (cpt6 between '99241' and '99245') or (cpt6 between '99271' and '99275')
or (cpt6 between '99301' and '99313') or (cpt6 between '99315' and '99316') or (cpt6 between '99318' and '99337') or (cpt6 between '99341' and '99350')
or (cpt6 between '99354' and '99355') or (cpt6 between '99381' and '99387') or (cpt6 between '99391' and '99397') or (cpt6 between '99401' and '99429')
or (cpt6= '99450') or (cpt6 between '99455' and '99456'))
or ((cpt7 between '99201' and '99205') or (cpt7 between '99211' and '99215') or (cpt7 between '99241' and '99245') or (cpt7 between '99271' and '99275')
or (cpt7 between '99301' and '99313') or (cpt7 between '99315' and '99316') or (cpt7 between '99318' and '99337') or (cpt7 between '99341' and '99350')
or (cpt7 between '99354' and '99355') or (cpt7 between '99381' and '99387') or (cpt7 between '99391' and '99397') or (cpt7 between '99401' and '99429')
or (cpt7= '99450') or (cpt7 between '99455' and '99456'))
or ((cpt8 between '99201' and '99205') or (cpt8 between '99211' and '99215') or (cpt8 between '99241' and '99245') or (cpt8 between '99271' and '99275')
or (cpt8 between '99301' and '99313') or (cpt8 between '99315' and '99316') or (cpt8 between '99318' and '99337') or (cpt8 between '99341' and '99350')
or (cpt8 between '99354' and '99355') or (cpt8 between '99381' and '99387') or (cpt8 between '99391' and '99397') or (cpt8 between '99401' and '99429')
or (cpt8= '99450') or (cpt8 between '99455' and '99456'))
or ((cpt9 between '99201' and '99205') or (cpt9 between '99211' and '99215') or (cpt9 between '99241' and '99245') or (cpt9 between '99271' and '99275')
or (cpt9 between '99301' and '99313') or (cpt9 between '99315' and '99316') or (cpt9 between '99318' and '99337') or (cpt9 between '99341' and '99350')
or (cpt9 between '99354' and '99355') or (cpt9 between '99381' and '99387') or (cpt9 between '99391' and '99397') or (cpt9 between '99401' and '99429')
or (cpt9= '99450') or (cpt9 between '99455' and '99456')))
or (((rev between '0500' and '0529') or (rev between '0570' and '0599') or (rev between '0770' and '0779') or (rev between '0820' and '0859')
or (rev between '0982' and '0983') or (rev = '0882')
or (rev1 between '0500' and '0529') or (rev1 between '0570' and '0599') or (rev1 between '0770' and '0779') or (rev1 between '0820' and '0859')
or (rev1 between '0982' and '0983') or (rev1 = '0882')
or (rev2 between '0500' and '0529') or (rev2 between '0570' and '0599') or (rev2 between '0770' and '0779') or (rev2 between '0820' and '0859')
or (rev2 between '0982' and '0983') or (rev2 = '0882')
or (rev3 between '0500' and '0529') or (rev3 between '0570' and '0599') or (rev3 between '0770' and '0779') or (rev3 between '0820' and '0859')
or (rev3 between '0982' and '0983') or (rev3 = '0882')
or (rev4 between '0500' and '0529') or (rev4 between '0570' and '0599') or (rev4 between '0770' and '0779') or (rev4 between '0820' and '0859')
or (rev4 between '0982' and '0983') or (rev4 = '0882')
or (rev5 between '0500' and '0529') or (rev5 between '0570' and '0599') or (rev5 between '0770' and '0779') or (rev5 between '0820' and '0859')
or (rev5 between '0982' and '0983') or (rev5 = '0882')
or (rev6 between '0500' and '0529') or (rev6 between '0570' and '0599') or (rev6 between '0770' and '0779') or (rev6 between '0820' and '0859')
or (rev6 between '0982' and '0983') or (rev6 = '0882')
or (rev7 between '0500' and '0529') or (rev7 between '0570' and '0599') or (rev7 between '0770' and '0779') or (rev7 between '0820' and '0859')
or (rev7 between '0982' and '0983') or (rev7 = '0882')
or (rev8 between '0500' and '0529') or (rev8 between '0570' and '0599') or (rev8 between '0770' and '0779') or (rev8 between '0820' and '0859')
or (rev8 between '0982' and '0983') or (rev8 = '0882')
or (rev9 between '0500' and '0529') or (rev9 between '0570' and '0599') or (rev9 between '0770' and '0779') or (rev9 between '0820' and '0859')
or (rev9 between '0982' and '0983') or (rev9 = '0882'))))
谁看看这个语句怎么能优化一下啊…… 求助高手啊 谢谢了啊………………
数据量很大的数据库啊…… 几百万的数据量
(dx1 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx2 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx3 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx4 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx5 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx6 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx7 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx8 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx9 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843'))
and ((((cpt between '99201' and '99205') or (cpt between '99211' and '99215') or (cpt between '99241' and '99245') or (cpt between '99271' and '99275')
or (cpt between '99301' and '99313') or (cpt between '99315' and '99316') or (cpt between '99318' and '99337') or (cpt between '99341' and '99350')
or (cpt between '99354' and '99355') or (cpt between '99381' and '99387') or (cpt between '99391' and '99397') or (cpt between '99401' and '99429')
or (cpt= '99450') or (cpt between '99455' and '99456'))
or ((cpt1 between '99201' and '99205') or (cpt1 between '99211' and '99215') or (cpt1 between '99241' and '99245') or (cpt1 between '99271' and '99275')
or (cpt1 between '99301' and '99313') or (cpt1 between '99315' and '99316') or (cpt1 between '99318' and '99337') or (cpt1 between '99341' and '99350')
or (cpt1 between '99354' and '99355') or (cpt1 between '99381' and '99387') or (cpt1 between '99391' and '99397') or (cpt1 between '99401' and '99429')
or (cpt1= '99450') or (cpt1 between '99455' and '99456'))
or ((cpt2 between '99201' and '99205') or (cpt2 between '99211' and '99215') or (cpt2 between '99241' and '99245') or (cpt2 between '99271' and '99275')
or (cpt2 between '99301' and '99313') or (cpt2 between '99315' and '99316') or (cpt2 between '99318' and '99337') or (cpt2 between '99341' and '99350')
or (cpt2 between '99354' and '99355') or (cpt2 between '99381' and '99387') or (cpt2 between '99391' and '99397') or (cpt2 between '99401' and '99429')
or (cpt2= '99450') or (cpt2 between '99455' and '99456'))
or ((cpt3 between '99201' and '99205') or (cpt3 between '99211' and '99215') or (cpt3 between '99241' and '99245') or (cpt3 between '99271' and '99275')
or (cpt3 between '99301' and '99313') or (cpt3 between '99315' and '99316') or (cpt3 between '99318' and '99337') or (cpt3 between '99341' and '99350')
or (cpt3 between '99354' and '99355') or (cpt3 between '99381' and '99387') or (cpt3 between '99391' and '99397') or (cpt3 between '99401' and '99429')
or (cpt3= '99450') or (cpt3 between '99455' and '99456'))
or ((cpt4 between '99201' and '99205') or (cpt4 between '99211' and '99215') or (cpt4 between '99241' and '99245') or (cpt4 between '99271' and '99275')
or (cpt4 between '99301' and '99313') or (cpt4 between '99315' and '99316') or (cpt4 between '99318' and '99337') or (cpt4 between '99341' and '99350')
or (cpt4 between '99354' and '99355') or (cpt4 between '99381' and '99387') or (cpt4 between '99391' and '99397') or (cpt4 between '99401' and '99429')
or (cpt4= '99450') or (cpt4 between '99455' and '99456'))
or ((cpt5 between '99201' and '99205') or (cpt5 between '99211' and '99215') or (cpt5 between '99241' and '99245') or (cpt5 between '99271' and '99275')
or (cpt5 between '99301' and '99313') or (cpt5 between '99315' and '99316') or (cpt5 between '99318' and '99337') or (cpt5 between '99341' and '99350')
or (cpt5 between '99354' and '99355') or (cpt5 between '99381' and '99387') or (cpt5 between '99391' and '99397') or (cpt5 between '99401' and '99429')
or (cpt5= '99450') or (cpt5 between '99455' and '99456'))
or ((cpt6 between '99201' and '99205') or (cpt6 between '99211' and '99215') or (cpt6 between '99241' and '99245') or (cpt6 between '99271' and '99275')
or (cpt6 between '99301' and '99313') or (cpt6 between '99315' and '99316') or (cpt6 between '99318' and '99337') or (cpt6 between '99341' and '99350')
or (cpt6 between '99354' and '99355') or (cpt6 between '99381' and '99387') or (cpt6 between '99391' and '99397') or (cpt6 between '99401' and '99429')
or (cpt6= '99450') or (cpt6 between '99455' and '99456'))
or ((cpt7 between '99201' and '99205') or (cpt7 between '99211' and '99215') or (cpt7 between '99241' and '99245') or (cpt7 between '99271' and '99275')
or (cpt7 between '99301' and '99313') or (cpt7 between '99315' and '99316') or (cpt7 between '99318' and '99337') or (cpt7 between '99341' and '99350')
or (cpt7 between '99354' and '99355') or (cpt7 between '99381' and '99387') or (cpt7 between '99391' and '99397') or (cpt7 between '99401' and '99429')
or (cpt7= '99450') or (cpt7 between '99455' and '99456'))
or ((cpt8 between '99201' and '99205') or (cpt8 between '99211' and '99215') or (cpt8 between '99241' and '99245') or (cpt8 between '99271' and '99275')
or (cpt8 between '99301' and '99313') or (cpt8 between '99315' and '99316') or (cpt8 between '99318' and '99337') or (cpt8 between '99341' and '99350')
or (cpt8 between '99354' and '99355') or (cpt8 between '99381' and '99387') or (cpt8 between '99391' and '99397') or (cpt8 between '99401' and '99429')
or (cpt8= '99450') or (cpt8 between '99455' and '99456'))
or ((cpt9 between '99201' and '99205') or (cpt9 between '99211' and '99215') or (cpt9 between '99241' and '99245') or (cpt9 between '99271' and '99275')
or (cpt9 between '99301' and '99313') or (cpt9 between '99315' and '99316') or (cpt9 between '99318' and '99337') or (cpt9 between '99341' and '99350')
or (cpt9 between '99354' and '99355') or (cpt9 between '99381' and '99387') or (cpt9 between '99391' and '99397') or (cpt9 between '99401' and '99429')
or (cpt9= '99450') or (cpt9 between '99455' and '99456')))
or (((rev between '0500' and '0529') or (rev between '0570' and '0599') or (rev between '0770' and '0779') or (rev between '0820' and '0859')
or (rev between '0982' and '0983') or (rev = '0882')
or (rev1 between '0500' and '0529') or (rev1 between '0570' and '0599') or (rev1 between '0770' and '0779') or (rev1 between '0820' and '0859')
or (rev1 between '0982' and '0983') or (rev1 = '0882')
or (rev2 between '0500' and '0529') or (rev2 between '0570' and '0599') or (rev2 between '0770' and '0779') or (rev2 between '0820' and '0859')
or (rev2 between '0982' and '0983') or (rev2 = '0882')
or (rev3 between '0500' and '0529') or (rev3 between '0570' and '0599') or (rev3 between '0770' and '0779') or (rev3 between '0820' and '0859')
or (rev3 between '0982' and '0983') or (rev3 = '0882')
or (rev4 between '0500' and '0529') or (rev4 between '0570' and '0599') or (rev4 between '0770' and '0779') or (rev4 between '0820' and '0859')
or (rev4 between '0982' and '0983') or (rev4 = '0882')
or (rev5 between '0500' and '0529') or (rev5 between '0570' and '0599') or (rev5 between '0770' and '0779') or (rev5 between '0820' and '0859')
or (rev5 between '0982' and '0983') or (rev5 = '0882')
or (rev6 between '0500' and '0529') or (rev6 between '0570' and '0599') or (rev6 between '0770' and '0779') or (rev6 between '0820' and '0859')
or (rev6 between '0982' and '0983') or (rev6 = '0882')
or (rev7 between '0500' and '0529') or (rev7 between '0570' and '0599') or (rev7 between '0770' and '0779') or (rev7 between '0820' and '0859')
or (rev7 between '0982' and '0983') or (rev7 = '0882')
or (rev8 between '0500' and '0529') or (rev8 between '0570' and '0599') or (rev8 between '0770' and '0779') or (rev8 between '0820' and '0859')
or (rev8 between '0982' and '0983') or (rev8 = '0882')
or (rev9 between '0500' and '0529') or (rev9 between '0570' and '0599') or (rev9 between '0770' and '0779') or (rev9 between '0820' and '0859')
or (rev9 between '0982' and '0983') or (rev9 = '0882'))))
谁看看这个语句怎么能优化一下啊…… 求助高手啊 谢谢了啊………………
数据量很大的数据库啊…… 几百万的数据量
解决方案 »
- oracle中修改字段为null 的写法
- pl/sql问题
- oracle 函数问题:java.sql.SQLException:ORA-01000:超出打开游标的最大数
- 如何得到一个日期的上个月?
- 开了两个SQL Plus,用同样的用户名登录同一个服务器,在一个SQL PLUS中向表写一条数据,用另一个SQL PLUS在同一个表中却找不到数据,为什
- date型数据约束
- 【delphi中利用ClientDataSet和ADOQuery分别如何调用oracle中的存储过程-JCC0128-400分奉上】
- SQL问题,请教
- 存储过程的问题(在线等待)
- oracle存储过程中字符串表达式的判断和字符串连接的问题
- oracle 触发器 如何实现记录曾经触发过的id,如何取这个记录的id的值
- 请教一个简单的小问题!!
from fo05
where (dx1 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx2,3,4,5,6,7,8,9)
and (( ((cpt between '99201' and '99205')
or (cpt between '99211' and '99215')
or (cpt between '99241' and '99245')
or (cpt between '99271' and '99275')
or (cpt between '99301' and '99313')
or (cpt between '99315' and '99316')
or (cpt between '99318' and '99337')
or (cpt between '99341' and '99350')
or (cpt between '99354' and '99355')
or (cpt between '99381' and '99387')
or (cpt between '99391' and '99397')
or (cpt between '99401' and '99429')
or (cpt = '99450')
or (cpt between '99455' and '99456') )
or (cpt1,2,3,4,5,6,7,8,9)
or (rev between '0500' and '0529') or (rev between '0570' and '0599') or (rev between '0770' and '0779') or (rev between '0820' and '0859')
or (rev between '0982' and '0983') or (rev = '0882')
or rev1,2,3,4,5,6,7,8,9));格式了下让后面的人看的清楚些,这个没法了。
或者
select distinct mbrid, dos from (
select mbrid, dos
from fo05
where (dx1 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
union all
select mbrid, dos
from fo05
where (dx2 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
..
);
用过程分步拆解可能好点
(( ((cpt between '99201' and '99205')
or (cpt between '99211' and '99215')
or (cpt between '99241' and '99245')
or (cpt between '99271' and '99275')
or (cpt between '99301' and '99313')
or (cpt between '99315' and '99316')
or (cpt between '99318' and '99337')
or (cpt between '99341' and '99350')
or (cpt between '99354' and '99355')
or (cpt between '99381' and '99387')
or (cpt between '99391' and '99397')
or (cpt between '99401' and '99429')
or (cpt = '99450')
or (cpt between '99455' and '99456') )
or (cpt1,2,3,4,5,6,7,8,9)
换成
where exists(select 1 from(
select '99201' a,'99205' b from dual union all
select '99211' ,'99215' from dual union all
...
select '99455','99456' from dual)where fo05.cpt1 between a and b
or fo05.cpt2 between a and b
or...)这里的全部条件都能换成这种形式,能减少些代码量
以上面的写法就是3个exists
楼主可以试试
没想到更好的办法
平生第一次看见一个where条件后面有这么多条件的。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
(狂浪) 用了你的那种方法,代码是少了很多啊
看起来也清晰,但是 速度却是降低了很多很多啊,为什么啊…… 我现在要求的就是执行的效率啊……
(jiaruimin11) 在存储过程里面怎么实现啊……
1、将这些代码值存入代码表,再在主表与代码表之间找逻辑关系;
2、若条件太多时,应将条件归类,将能合并的条件通通合并
比如:a > 1 and a>2 合并为a > 2
3、实在无法简化时,就将不同的逻辑类做成视图或子表,这样更能直观表述你的逻辑
这一段可以改成Instr('40201,40211,40291,40401,40411,40491,4280,4281,42820,42821,42822,42823,42840,42841,42842,42843', dx?) > 0
然后,在 fo05 表上建函数索引
create inext fo05_dx1 on fo05 (instr(Instr('40201,40211,40291,40401,40411,40491,4280,4281,42820,42821,42822,42823,42840,42841,42842,42843', dx1) tablespace 索引表空间;
create inext fo05_dx1 on fo05 (Instr('40201,40211,40291,40401,40411,40491,4280,4281,42820,42821,42822,42823,42840,42841,42842,42843', dx1) tablespace 索引表空间; 另外:楼主
类似cpt between '99201' and '99205' 99301-99205中的值是否有规律。
create view test_dx as select distinct mbrid,dos from fi05 where
(
dx1 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or dx2 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
or
.....
or dx9 in('40201', '40211', '40291', '40401', '40411', '40491','4280', '4281', '42820','42821','42822','42823',' 42840','42841','42842','42843')
) create view test_cpt as select distinct mbrid,dos from fi05 where
((cpt between '99217' and '99220') or (cpt between '99234' and '99236'))
or ((cpt1 between '99217' and '99220') or (cpt1 between '99234' and '99236'))
....
or ((cpt9 between '99217' and '99220') or (cpt9 between '99234' and '99236'))
create view test_rev as select distinct mbrid,dos from fi05 where
((rev between '0500' and '0529') or (rev between '0570' and '0599') or (rev between '0770' and '0779') or (rev between '0820' and '0859' )
or (rev between '0982' and '0983') or (rev = '0882'))
or((rev1 between '0500' and '0529') or (rev1 between '0570' and '0599') or (rev1 between '0770' and '0779') or (rev1 between '0820' and '0859')
or (rev1 between '0982' and '0983') or (rev1 = '0882'))
......
or ((rev9 between '0500' and '0529') or (rev9 between '0570' and '0599') or (rev9 between '0770' and '0779') or (rev9 between '0820' and '0859')
or (rev9 between '0982' and '0983') or (rev9 = '0882'))
select a.mbrid from fi05 a,test_dx b,test_cpt c,test_rev d where a.mbrid = b.mbrid and (a.mbrid = c.mbrid or a.mbrid = d.mbrid)
是这样嘛?