出错的SQL语句(红色是出错的地方):
select * from ( select row_.*, rownum rownum_ from ( SELECT * FROM (SELECT d.*,NAME FROM T_DOCUMENT d INNER JOIN TABLE1 m ON d.MAPPINGID=m.ID WHERE d.ISTMP = 0) ordtb WHERE DOMAINID ='11e0-762c-d31286b0-abd4-2d7ef7253046' ORDER BY ordtb.ID ) row_ where rownum <= 10) where rownum_ > 0