You can use the Rank () function to rank your rows
based on a simple or complex criteria in a subquery or
an inline view and then extract the requisite set by
using a simple condition on the Rank col. Below is a
simple example just to give you some idea of what is
possible. You may want to take a
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.*
Dear DBA Gurus,
How do I select and display 10 records at a time from a table using sql
query only?
Thanks and Regards,
Ranganath
DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
select * from ( select column1, column2 from my_table order by 1) where
ROWNUM 11;
Look at manual how to use ROWNUM.
It's ease to make mistakes with it.
JP
Dne st 29. srpen 2001 10:55 jste napsal(a):
Dear DBA Gurus,
How do I select and display 10 records at a time from a table using
Does anybody know how to do it better way?
But this will return only the first ten rows not subsequent sets. How do I
display rows from 11 to 20, 21 to 30 and so on?
ROWNUM is counting output tuples. You cannot use ROWNUM 10.
I think you have to order select by your primary key, make filter