关于rownum的一个问题,请大家帮忙
SQL> select * from (select A.*,B.* from person A,drivinglicense B where A.sfzmhm=B.sfzmhm and A.xm like '%王伟%') where rownum<=100;
select * from (select A.*,B.* from person A,drivinglicense B where A.sfzmhm=B.sfzmhm
*
ERROR 位于第 1 行:
ORA-00918: column ambiguously defined
当然select * from (select A.sfzmhm,B.dabh from person A,drivinglicense B where A.sfzmhm=B.sfzmhm and A.xm like '%王伟%') where rownum<=100这样是正确的,但是字段太多,我不想把都列出来,不然语句太长!
请问怎么办?