OraFAQ Forum: SQL & PL/SQL » rownum problem

Home » SQL & PL/SQL » SQL & PL/SQL » rownum problem

Fri, 03 January 2014 01:45

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

Below query gives 3 rows..

SELECT ROWNUM,ename from emp WHERE ROWNUM BETWEEN 1 and 3

Please see the below query , it returns no rows returned.

WHERE ROWNUM BETWEEN 2 and 3

What is the problem , how can i get?

Thank You

Fri, 03 January 2014 02:09

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ "What is the problem", read ROWNUM Pseudocolumn
2/ "how can i get?", read Can one retrieve only rows X to Y from a table?

Fri, 03 January 2014 02:17

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Yes it is working now Thank You.. Smile

Previous Topic:	Please provide best approach for my requirement.
Next Topic:	Write a trigger - help

Goto Forum:

]

Current Time: Thu Apr 25 10:43:44 CDT 2024