日期:2014-05-16  浏览次数:20395 次

关于like语句的循环查询

?

select s.uecode,s.codedic  from sys_function s ,(select uecode uecode from sys_function  where fid in(0013000000,0014000000)) t
  where s.uecode like t.uecode||'%' order by s.uecode

?