这样试试:select * from (Select user_id,number1,loginName,rownum a
from user_register order by user_id) where a>=1 and a<=4;select * from (Select user_id,number1,loginName,rownum a
from user_register order by user_id) where a=1;
from user_register order by user_id) where a>=1 and a<=4;select * from (Select user_id,number1,loginName,rownum a
from user_register order by user_id) where a=1;
----------
224
225
226
227
229
241已选择6行。^_^>>select a.*,rownum from (select id,rownum rnum from tt where rownum<=4 order by id) a where rnum>=1; ID RNUM ROWNUM
---------- ---------- ----------
224 1 1
225 2 2
226 3 3
227 4 4
这是什么原因?怎么没有显示出:
229 mm qxm
经过order by 229的rownum>4,所以没显示
(select rownum, a.user_id, a.number1, a.loginName
from (Select user_id,number1,loginName
from user_register
where rownum<=4 order by user_id) a)
where rownum between 1 and 4;
select user_id,number1,loginName from
(select rownum, a.user_id, a.number1, a.loginName
from (Select user_id,number1,loginName
from user_register
where rownum<=4 order by user_id) a)
where rownum=1;