SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM RMC_SR_DOCTOR) A WHERE ROWNUM <= (10)) WHERE RN > 0;
分页查询，想要哪几条就要哪几条
select * from table_name where rownum<100;
