Re: Limiting Returned Rows In Select Statement

Actually, I don't think that I can use RowNum because there are no instances of my query within the first 16 rows. If I do the query:

select * from ImageData where PartNumber like 'ois-204%'

Then the first occurrance is at RowNum 1214. Therefor limiting the query to 'RowNum < 16

AH HA!

I think I get it now. Boy, don't you just love those moments of clarity? :) Thanks.

MC

On Tue, 24 Feb 1998 16:50:39 -0000, Vinay Joshi <vjoshi_at_pinnacle.co.uk> wrote:

>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