Re: HELP !!!!

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 03 Jul 1999 18:14:09 +0800
Message-ID: <377DE271.6101@yahoo.com>

Ulrik Hoffmann wrote:
>
> > 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

This gets you 100 rows but not necessarily the "top" 100 rows (dependent of course on what the original poster meant by "top") --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sat Jul 03 1999 - 05:14:09 CDT