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 -> Limiting Returned Rows In Select Statement

Limiting Returned Rows In Select Statement

From: Matthew Chappee <matthew_at_nospam.mattshouse.com>
Date: 1998/02/24
Message-ID: <34f2f187.78918028@ntserv02>#1/1

Here is the query that I'm trying to execute:

Select PartNumber, OrderNumber, Description From ImageData
Where PartNumber like 'ois-204%'

This statement returns 200 rows from the database. I want it to only return 15. I can't use 'and RowNum < 16' because there are no entries with that criteria. How do I do this?

Matthew Received on Tue Feb 24 1998 - 00:00:00 CST

Original text of this message

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