select * from (
select tt.*,rownum rn from (
select id ,showname from tab_20151221162123 where 1=1 and showname like '%%'
union
select id,showname from tab_20151221173807 where 1=1 and showname like '%%'
) tt )where rn between 1 and 20
多表集合查询时 查询的字段数需保持一致
select tt.*,rownum rn from (
select id ,showname from tab_20151221162123 where 1=1 and showname like '%%'
union
select id,showname from tab_20151221173807 where 1=1 and showname like '%%'
) tt )where rn between 1 and 20
多表集合查询时 查询的字段数需保持一致