Dear all,
Here is the query to do the same:
select outer.* from(select inner.*,ROWNUM as Query_Rownum from
(select * from tablename)inner where Rownum =to) outer where
Outer.Query_Rownum=from
/
Hope this helps!
Regards,
Ranganath
DISCLAIMER: This correspondence is confidential and
your query is equivalent to ,
select * from tablename where rownumnum =10;
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 30, 2001 2:55 PM
using sql query - Solved
Dear all,
Here is the query to do the same:
select outer.*
