Re: HELP !!!!

From: <pierre_gilles_at_my-deja.com>
Date: Mon, 05 Jul 1999 07:13:31 GMT
Message-ID: <7lplun$cos$1@nnrp1.deja.com>

Hi,
Try to use rownum pseudo-column as :
SELECT *
FROM MyTable
WHERE rownum <= 100;

Hope this helps...

In article <7lo9ru$dg0$1_at_wanadoo.fr>,
"Laurent TESTA" <laurent.testa_at_wanadoo.fr> wrote:
> Hello ,
> I want the 100 first record of a SQL request with Oracle 8.0.5 with
VB5 W95
> TOP don't work ! with where and group by
> How can i do ????
> Thanks for your answer...
> Laurent
>
> laurent.testa_at_wanadoo.fr
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 05 1999 - 02:13:31 CDT