title: Does sqlite support reading certain number of rows for each query?
body: <p>My Android application has an activity to present data from SQLite database. The db table might contain huge number of rows. For performance reasons, I want to load 20 rows from db at a time, and when user scrolls down listview to the end, read next 20 rows.</p>
  
  <p>So I want to use SQL statement like this:</p>
  
  <pre><code>select * from mytable where id &gt; N and count = 20;
  </code></pre>
  
  <p>I just wonder if SQLite supports this kind of <code>"count=20"</code> feature to read at maximum 20 rows for the query. If it is supported, what is exact syntax?</p>