In mysql I believe you can use OFFSET and LIMIT in a JBOSS-QL query but there is not (AFAIK) an equivalent in oracle, instead you need to do something like...
select name from (select name,rownum r from plan) where r > 2 and r < 10; (I think the MYSQL equivalent is 'select name from plan offset 2 limit 7') I don't think that there is anyway to express this in JBOSS-QL to generate the appropriate oracle sql. Anybody with a better knowledge of jbossql and oracle know how I can do this so I can limit the size of my individual queries on a very large dataset? thanks, brian wallis... ------------------------------------------------------- This SF.net email is sponsored by OSDN's Audience Survey. Help shape OSDN's sites and tell us what you think. Take this five minute survey and you could win a $250 Gift Certificate. http://www.wrgsurveys.com/2003/osdntech03.php?site=8 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user