SELECT td1,td2,td3,td1 from table ,这样写是没问题的能执行,但是加上 rownum后报错
select * from (SELECT td1,td2,td3,td1 from table) where rownum <= 30
原因是有重复列,去掉重复列就好了
SELECT td1,td2,td3,td1 from table ,这样写是没问题的能执行,但是加上 rownum后报错
select * from (SELECT td1,td2,td3,td1 from table) where rownum <= 30
原因是有重复列,去掉重复列就好了