SELECT *

FROM (SELECT ROWNUM AS rowno, t.*

FROM mip_org_user t

WHERE ROWNUM <= 20) table_alias

WHERE table_alias.rowno >= 10;