Re: Limiting Returned Rows In Select Statement

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.

Matthew

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