Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00,YGBH00,DBKL00 from VW_ZY_DBQXB0 where 
( XKH000 like '%' or PYSM00 like '%' or WBSM00 like '%' or ZWMC00 like '%' )  and (  BZ0000 = '2' )  order by XKH000,PYSM00) where Rownum<=500