| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: SELECT
"Andreas Stephan" schrieb
> select * from tablename where ROWNUM < 11;
OK, but how can I select row 11 to 20?
select * from tablename where ROWNUM BETWEEN 11 AND 20;
doesn't work.
Regards,
Uli
Received on Fri Sep 21 2001 - 07:18:56 CDT
 |
 |