5 messages in com.mysql.lists.mysqlRE: ORACLE question
FromSent OnAttachments
Kazazic, Almir07 Dec 1999 04:08 
Fraser MacKenzie07 Dec 1999 06:30 
indrek siitan07 Dec 1999 06:35 
Fraser MacKenzie07 Dec 1999 06:46 
Sasha Pachev07 Dec 1999 06:58 
Subject:RE: ORACLE question
From:indrek siitan (tf@cafe.ee)
Date:12/07/1999 06:35:45 AM
List:com.mysql.lists.mysql

Hey,

Ask this question on an Oracle list :-) Actually, I think this is what you want: SELECT * FROM test WHERE ROWID() >= 10 AND ROWID() < 20

almost. :)

SELECT rownum,field1,field2 FROM test WHERE rownum <=10

but the limitations:

1. you can't use "where rownum>=10 and rownum<=20". you have to use "where rownum<=20" and drop first 10 by yourself.

2. rownum's are applied BEFORE order by, so you can't use them together.

but, if there's a will, there's a way. subselects are the keyword.

Rgds, Tfr