How to Retrieve particular rows ?.

Can any one help me ?.

I have problem with the following query :

select coll , rownum from table1 where

    col1 <= 'some value1 ' and
    col2 = 'some value2' and
   rownum <= 10
order by col1 desc.

Both col1 and col2 are the primary keys of table table1, and there is also and index on both the columns.

The query returns first 10 rows always ( irrespective of the " col1 <= 'some value1 ' " ) , which is not i expected. I need 10 rows starting from 'some value1' in desc order and rownum from 1 to 10.

Thanks,
Raj. Received on Tue Apr 04 2000 - 00:00:00 CEST