Select * from (select DM0000,VALUE0,PYSM00,WBSM00 from XT_ZD0000 where (PYSM00 Like '%') and(  ZDMC00 like '%¹Øϵ%' and ZDBM00='LXRGX0' )  Order By PYSM00) where Rownum<=30