RE: ORACLE question - indrek siitan - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRE: ORACLE question

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