title: How to query first 10 rows and next time query other 10 rows from table
body: <p>I have more than 500 rows with in my Database Table with particular date. </p>
  
  <p>To query the rows with particular date.</p>
  
  <pre><code>select * from msgtable where cdate='18/07/2012'
  </code></pre>
  
  <p>This returns 500 rows.</p>
  
  <p>How to query these 500 rows by 10 rows step by step. 
  Query First 10 Rows and show in browser,then query next 10 rows and show in browser?</p>