Home » SQL & PL/SQL » SQL & PL/SQL » Rownum and Between
Rownum and Between [message #242513] Sun, 03 June 2007 05:32 Go to next message
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 Go to previous messageGo to next message
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.
Re: Rownum and Between [message #242538 is a reply to message #242520] Sun, 03 June 2007 13:28 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
That's right.

Regards
Michel
Previous Topic: Query Help!!!!!!!!!!!!!!
Next Topic: could i change the language evironment in oracle9i?
Goto Forum:
  


Current Time: Fri Dec 09 00:01:03 CST 2016

Total time taken to generate the page: 0.12760 seconds