SELECT *FROM (  select A.* from vw_ys_zlxmsrf_mzdzbl A where 1=1  and  UPPER(pysm00) like 'RCH%' and sfje00>0 and a.lbbh00 in (1,2,3,5,6,7,8,9,10,20,21) order by pysm00) WHERE ROWNUM<=100