Re: How to Retrieve particular rows ?.

Paul,
Thanks for your response ,
 I tried the query and it's giving an eror with "order by" clause in 8.0.5 .

Paul Druker wrote:

> Try:
>
> select coll , rownum from (
> select * from table1 where
> col1 <= 'some value1 ' and
> col2 = 'some value2'
> order by col1 desc)
> where rownum <= 10
>
> Regards,
> Paul
>
> "Raj" <rajarulmani_at_att.com> wrote in message
> news:38EA6880.BAC94B8B_at_att.com...
> > 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 Wed Apr 05 2000 - 07:39:04 CDT