select * from (select rownum rn,ps.* from (select * from user_t) ps ) where rn>=1 and rn<=10 //从第一页开始,第十行结束