Re: FETCH ROWS ???

Try

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

"Dulli" <dulli_at_dulli.com> wrote in message news:saVY7.6873$zZ5.138012_at_news.kpnqwest.fi...
> 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 - 11:26:57 CST