> I know mysql supports the LIMIT keyword to control the size of > the result set, but I'm fairly certain Oracle doesn't. In ORACLE if you want to limit the number of results you would use ROWNUM. So if you wanted items 50 to 100 you would do the following SELECT bar.rn, bar.coldata FROM ( SELECT ROWNUM rn, coldata FROM foo } bar WHERE bar.rn BETWEEN 50 AND 100 Amith