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 Wed Jan 02 2002 - 20:02:56 CST
