Re: HELP !!!!!

For simple SQL, you can use
select * from tab
where rownum <= 100.
But you can't use order by or group by, because Oracle first fetch those 100 rows and then do order by or group by, which may not be what you really need.

Regrads.

Michael Zhang

Laurent TESTA <laurent.testa_at_wanadoo.fr> wrote in message news:7lo9uh$di9$1_at_wanadoo.fr...
> Hello ,
> I want the 100 first record of a SQL request with Oracle 8.0.5 with VB5
W95
> TOP don't work ! with clause where and group by
> How can i do ????
> Thanks for your answer...
> Laurent
>
> laurent.testa_at_wanadoo.fr
>
>
>
>
>
>
Received on Sun Jul 04 1999 - 18:36:06 CDT