title: What is a query offset?
body: <p>I saw this at the Kohana documentation:</p>
  
  <pre><code>$content = new View('pages/items');
  $items = new Items_Model;
  
  $content-&gt;items = $items-&gt;get_items($page_no, 10); // page to get starting at offset, number of items to get
  </code></pre>
  
  <p>As you can see, we can assume that we have get_items method for Items model that receives 2 parameters, $page_no and 10 (as shown here). I know that 10 is the number of items to get and $page_no is the page to get starting at offset</p>
  
  <p>I can probably implement a limit sql statement for the 10 parameter, but what sql statement will correspond to $page_no? What does Kohana mean regarding "page to get starting at offset"</p>