Re: How to select only the first 20 rows in a SQL statement

From: Glen Gorman <fafhrd_at_nbnet.nb.ca>
Date: Mon, 25 Oct 1999 17:17:58 GMT
Message-ID: <381490C5.A948F7F3@nbnet.nb.ca>

use a count colum and constrain it by 20.

Loo Kean Fui wrote:

> Hello
>
> Can anyone help ?
>
> I need to issue an SQL statement (either select, delete or update) that
> I want to perform only on the first 20 rows returned and then
> subsequently repeat the statement on the next 20 rows and so on and so
> forth
>
> Is there any way I can write sucha statement?
>
> --
> L OO
> Kean Fui
Received on Mon Oct 25 1999 - 12:17:58 CDT

This message: [ Message body ]
Next message: Eric Dantie: "Re: How to do an online backup?"
Previous message: Thomas Kyte: "Re: EXEC SQL <action> and EXEC SQL EXECUTE IMMEDIATE :<host of action>"
In reply to: Loo Kean Fui: "How to select only the first 20 rows in a SQL statement"

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