Re: How to extract "nn" row from a table

From: Michael MacDonald <MichaelMacDonald_at_iname.com>
Date: Thu, 4 Jun 1998 10:42:15 -0400
Message-ID: <6l6boa$5i9$1@newsfeed2.ftn.net>

Jean-Gwilherm Praud wrote in message <6l3vj1$hdm$1_at_minus.oleane.net>...
>Hello,
>
>I Have to extract just the 10 first results row of my sql query !
>how can I do simply.
>
>Thank.

The technique I use is to add a where clause of the form "WHERE RowNum<=10"

Michael A. MacDonald

---

Oracle DBA & Web Developer
<A HREF="http://www.passport.ca/>Passport Online</A> Received on Thu Jun 04 1998 - 09:42:15 CDT