Re: FETCH ROWS ???

Hi Jim

When I try this row

> select * from (select * from table order by ...) where rownum<100;

I get this error message

ERROR at line 1:
ORA-00907: missing right parenthesis

Seems like Oracle 7.x don't accept these kind of selects.

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:kZOY7.5910$Qe1.51209_at_rwcrnsc53...
> The order by occurs after the 100 rows are chosen so that won;t work.
> select * from (select * from table order by ...) where rownum<100;
> Jim
> <davide_at_yahoo.com> wrote in message
> news:a0v7cg$n2dgn$2_at_ID-18487.news.dfncis.de...
> > Dulli <dulli_at_dulli.com> wrote:
> > > How can I do somthing like this in Oracle 7.x ?
> > > Select top 100 * from table order by timestamp desc
> >
> > SELECT * FROM TABLE WHERE ROWNUM <= 100 ORDER BY...
> >
> > See the documentation on http://technet.oracle.com
> >
> > Davide
>
>
Received on Thu Jan 03 2002 - 03:06:32 CST