| Rownum and Between [message #242513] |
Sun, 03 June 2007 05:32  |
roy_mm
Messages: 3
Registered: December 2006
|
Junior Member |
|
|
Hello.
I'm using oracle 10g and I tried to use the rownum with between
(select * from table where rownum between 5 and 20)but I Found out it doesn't work!
only if I start the between with 1 it works.
Is there a way to do that?
I'm tring of course to get only the records from the 5 record to the 20.
Thanks,
Roy.
[Updated on: Sun, 03 June 2007 07:49] Report message to a moderator |
|
|
|
| Re: Rownum and Between [message #242520 is a reply to message #242513] |
Sun, 03 June 2007 07:50  |
roy_mm
Messages: 3
Registered: December 2006
|
Junior Member |
|
|
Hi all, I got an answer for my question.
It seems like the rownum doesn't work like i thought he does.
The simple way is to use a few sub query and create a dummy column for the rownum.
Thanks.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
