title: Get next N rows starting from any row SQLite
body: <p>I'm querying an SQLite database and want to get the next n rows starting from any row. I know that <code>SELECT TOP 10 * FROM TABLENAME</code> will return the top 10 results but is there a way to do it say starting from rownumber 20 and selecting the next 10 results after that?</p>
  
  <p>I need to edit this query...</p>
  
  <pre><code> public Soul[] SoulList(string row, string itemsPerRow)
          {
              Soul[] rval = null;
              using (var sqlCommand = new SQLiteCommand("SELECT * FROM SOULS"))
              {
                  rval = GetSouls(sqlCommand);
              }
  
              return rval;
          } 
  </code></pre>