Re: Restrict the number of records

From: Pete Johnson <P.Johnson_at_ste0426.x400.icl.co.uk>
Date: Tue, 05 Jan 1999 12:48:43 GMT
Message-ID: <36920a1d.17299425@news.cafevik.icl.co.uk>

where rownum < 11

On Tue, 5 Jan 1999 11:43:35 +0100, "G. Kakisina" <ivkaki_at_hvision.nl> wrote:

>Hi,
>
>I want to know if it is possible to restrict the number of records to show
>when using a SELECT statement.
>For example, i got a table with a thousand records. When I use a SELECT
>statement, 500 records show up. I only want 10 results. How can i do this?
>
>G. K.
>
>
Received on Tue Jan 05 1999 - 06:48:43 CST

This message: [ Message body ]
Next message: Stewart Burnett: "Re: question on access Oracle Web Application Server from dial-up networking"
Previous message: kyutae lim: "help me!!! how can I insert data(pro*c)?"
In reply to: G. Kakisina: "Restrict the number of records"
Next in thread: Matt: "Re: Restrict the number of records"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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