how do limit in db2 iseries? i have table more 50,000 records , want return records 0 10,000, , records 10,000 20,000. i know in sql write limit 0,10000 @ end of query 0 10,000 , limit 10000,10000 @ end of query 10000 20,000 so, how done in db2? whats code , syntax? (full query example appreciated) using fetch first [n] rows only : http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.perf/db2z_fetchfirstnrows.htm select lastname, firstname, empno, salary emp order salary desc fetch first 20 rows only; to ranges, you'd have use row_number() (since v5r4) , use within where clause: (stolen here: http://www.justskins.com/forums/db2-select-how-to-123209.html ) select code, name, address ( select row_number() on ( order code ) rid, code, name, address contacts name '%bob%' ) t t.rid between 20 , 25;