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;
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;