Re:Limiting Returned Rows In Select Statement

You are almost there! Yes you can use rownum < 16... I think you are in the impression that rownum has to be a tablename..well it is not. ROWNUM is a PSUEDO COLUMN and therefore you cant see it in the user_tab_columns..

> -----Original Message-----
> From: matthew_at_nospam.mattshouse.com (Matthew Chappee)
> [SMTP:matthew_at_nospam.mattshouse.com]
> Posted At: 24 February 1998 16:17
> Posted To: server
> Conversation: Limiting Returned Rows In Select Statement
> Subject: 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