title: How can I select rows by range?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/8976925/select-statement-in-sqlite-recognizing-row-number">Select statement in SQLite recognizing row number</a>  </p>
  </blockquote>
  
  
  
  <p>For example, <code>SELECT * FROM table WHERE [row] BETWEEN x AND y</code></p>
  
  <p>How can this be done? I've done some reading but haven't found anything specifically correct.</p>
  
  <p>Imagine a list where you want results paged by an X amount of results, so for page 10 you would need results from rows 10 * X to 10 * X + X. Rather than display ALL results in one go</p>