Oracle 中实现分页语句

select user_id,user_name,password,telephone,email,creat_date
from
(
  select rownum rn,user_id,user_name,password,telephone,email,creat_date
  from
  (
         select rownum rn,user_id,user_name,password,telephone,email,creat_date from t_user where user_id <> 'root' order by user_id
  )
  where rn < =3
)
where rn>=1;