Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Limiting Returned Rows In Select Statement
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
![]() |
![]() |