Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to select a range of records by rownum?
I want to select records from 40 to 100, and I think the statement
"select rownum, user, email from clients where rownum >= 40 and rownum <=100"
will work. But it failed, I tried
"select rownum, user, email from clients where rownum <= 100"
it work. But
"select rownum, user, email from clients where rownum >= 40" failed, can
anybody help me.
Below is the result of the query
"select rownum, user, email from clients where rownum <= 100", just for your
reference.
SQL> select rownum, username, email from clients where rownum <= 100;
ROWNUM USERNAME Email --------- ------------------------------ ------------------- 1 SYS sys_at_hul.com.hk 2 SYSTEM master_at_hul.com.hk . . . . 99 Peter peter_at_hotmail.com 100 Mulder mulder_at_xfile.comReceived on Mon Mar 24 1997 - 00:00:00 CST
![]() |
![]() |