Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP !!!!

Re: HELP !!!!

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Fri, 2 Jul 1999 21:54:04 +0100
Message-ID: <7lj5ct$6t6$1@freeside.cls.net>


> Hello ,
> I want the 100 first record of a SQL request with Oracle 8.0.5 with VB5
W95
> TOP don't work !

Hi,
try this:

select * from MyTable where rownum <=100

Bye
Uli Received on Fri Jul 02 1999 - 15:54:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US