81,091
社区成员
发帖
与我相关
我的任务
分享
select * from (select f.*,rownum row_ from (select * from tablename) f where rownum<=12)where row_>=2;
select * from (select f.*,rownum row_ from (select * from tablename) f) where rownum<=12 and row_>=2;
--第一条子查询中出12条记录row_筛选掉<1的一条就只有一条了
select t.*,rownum from (select f.*,rownum row_ from (select * from tbsysuserinfo) f where rownum<=12)t where row_>=2;
--第二条子查询中出所有记录row_筛选掉子查询中<2的、而rownum属于 t 的、而不是 f 的、它筛选掉的是 t 中<=12并不是 f 中的。
select t.*,rownum from (select f.*,rownum row_ from (select * from tbsysuserinfo) f) t where rownum<=12 and row_>=2;
select t.*,rownum from (select f.*,rownum row_ from (select * from tablename) f where rownum<=12)t where row_>=2;
select t.*,rownum from (select f.*,rownum row_ from (select * from tablename) f) t where rownum<=12 and row_>=2;
select * from (select f.*,rownum row_ from (select * from tablename) f) where row_<=12 and row_>=2;