Re: retriving particular rows in order - Thanx [message #372764] |
Wed, 07 March 2001 09:37 |
Siddharth Bahri
Messages: 18 Registered: March 2001
|
Junior Member |
|
|
Hi Kavitha,
Thanku very much.
This has done the job
but I had to use order by clause three times. I had to put the order by clause in the end to order the rows finally returned by the query (I wanted desc order)
select * from
(
select field_name
from tablename
order by field_name desc
)
where rownum <= 20
minus
select * from
(
select field_name
from tablename
order by field_name desc
)
where rownum <= 10
order by field_name desc;
I think this would be a bit inefficient
There's got to be a more efficient solution
so I am still looking for a more efficient solution.
Thanx again
Siddharth
|
|
|