select * from (select t.cf,acc.stdcode,acc.stdname from gl_balance t inner join md_accountsubject acc on t.subjectid = acc.recid order by t.cf) where rownum < 10;
order by 和rownum不能同时使用,使用的话结果不会生效。
select * from (select t.cf,acc.stdcode,acc.stdname from gl_balance t inner join md_accountsubject acc on t.subjectid = acc.recid order by t.cf) where rownum < 10;
order by 和rownum不能同时使用,使用的话结果不会生效。