title: Equivalent of LIMIT for DB2
body: <p>How do you do <code>LIMIT</code> in DB2 for iSeries? </p>
  
  <p>I have a table with more than 50,000 records and I want to return records 0 to 10,000, and records 10,000 to 20,000.</p>
  
  <p>I know in SQL you write  <code>LIMIT 0,10000</code> at the end of the query for 0 to 10,000 and <code>LIMIT 10000,10000</code> at the end of the query for 10000 to 20,000 </p>
  
  <p>So, how is this done in DB2? Whats the code and syntax?
  (full query example is appreciated)</p>