Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting Returned Rows In Select Statement

Re: Limiting Returned Rows In Select Statement

From: Satish Narasimha <satishn_at_blr.sni.de>
Date: 1998/02/25
Message-ID: <34F3A1EF.D9B@blr.sni.de>#1/1

Matthew Chappee wrote:
>
> OK, I now understand what you're saying. But how do I get the next
> 15? Is this legal?
>
> select * from Imagedata where RowNum > 15 and RowNum < 31
>
> I can't get this one to work.
>

hello,

    This is possible i have written queries to find out in b/w numbers... but i don't get the method.. I can give the hint...   U use in Operator in a subquery. and get the result.... Received on Wed Feb 25 1998 - 00:00:00 CST

Original text of this message

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