title: SQL Lite blank row id even after deleting the row
body: <p>I have a SQLite DB file lets say a.db. And I have 100 rows in table a. When I give </p>
  
  <pre><code>SELECT * FROM a WHERE rowid BETWEEN 1 AND 100
  </code></pre>
  
  <p>it gives me the first 100 results. Now if I delete the first 2 rows from the table and run the </p>
  
  <pre><code>SELECT * FROM a WHERE rowid BETWEEN 1 AND 100 
  </code></pre>
  
  <p>it gives me only 98 rows. And when I give the query</p>
  
  <pre><code>SELECT * FROM a WHERE rowid = 1 
  </code></pre>
  
  <p>it gives me an empty row. The database doesn't seem to rearrange the rowid.</p>
  
  <p>Please help.. Is there any way to force the SQLite to rearrange the row ids ?</p>