Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to select only the first 20 rows in a SQL statement
add "where rownum <21" to the statement.
Glen Gorman wrote:
> 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 Wed Nov 10 1999 - 01:07:36 CST