oracle数据库分页查询

select memberid, membername from(select memberid,membername,rownum as num from t_member)where num between 10 and 20;