我尝试过用rowid和rownum,有问题。
因为后面的select 语句涉及的表多,而且语句有点复杂。
如同下面的这样:
select * from ((select* from ... group by) a full outer join (select * from ... group by) b on ...
full outer join (select * from ... group by) c on ...
原帖由 lslovechina 于 2008-10-27 16:50 发表
我尝试过用rowid和rownum,有问题。
因为后面的select 语句涉及的表多,而且语句有点复杂。
如同下面的这样:
select * from ((select* from ... group by) a full outer join (select * from ... group by) b on ...
full outer join (select * from ... group by) c on ...