title: Select statement in SQLite recognizing row number
body: <p>I want to write SQLite statement something like this:</p>
  
  <pre><code>SELECT * FROM Table WHERE RowNumber BETWEEN 1 AND 10;
  </code></pre>
  
  <p>but i don't have such column RowNumber. I have primary key in my table. But is there row number by default that i could use ? </p>
  
  <p>Also i am searching info about writing more complicated SQLite statement. So if you have some links in bookmarks please share.</p>
  
  <p>Thanks.</p>