Re: Restrict the number of records

From: Matt <matt_at_cownie.freeserve.co.uk>
Date: Wed, 06 Jan 1999 22:19:39 +0000
Message-ID: <3693E17B.B5B3B6BD@cownie.freeserve.co.uk>

where rownum < 10

"G. Kakisina" 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 Wed Jan 06 1999 - 16:19:39 CST

This message: [ Message body ]
Next message: Joel R. Kallman: "Re: ADO with Oracle"
Previous message: Ed Zappulla: "jdbc driver for oracle"
In reply to: G. Kakisina: "Restrict the number of records"
Next in thread: John Harris: "Use rownum only if the select is not ordered"

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