Oracle两个表连接的分段查询

Select * From ( Select RowNum field_ByName,b.* From ( SELECT c.name cname,d.loginaccount,e.name FROM JITUMS.TB_READERS c ,jitums.tb_rd_account d,jitums.tb_rd_type e where c.rdtypecode= e.rdtypecode and c.reader_id= d.reader_id ) b Where RowNum <= 10 ) A Where A.field_ByName > 0

三个表连接，其中两个表里有一列名字相同，得重命名c.name cnam

还可以写为：

SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM JITUMS.TB_READERS ) A WHERE ROWNUM <=10 WHERE RN > 0