本文介绍了一个复杂的SQL查询案例，该查询旨在从用户表中选择除特定用户ID外的所有用户信息，并按用户ID排序。通过使用多层子查询及ROWNUM进行结果集的筛选，展示了高级的SQL技巧。
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;
扫一扫
31万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
