jeudi 18 février 2016

Get next N rows starting from any row SQLite

I'm querying an SQLite database and want to get the next n rows starting from any row. I know that SELECT TOP 10 * FROM TABLENAME 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?

I need to edit this query...

 public Soul[] SoulList(string row, string itemsPerRow)
        {
            Soul[] rval = null;
            using (var sqlCommand = new SQLiteCommand("SELECT * FROM SOULS"))
            {
                rval = GetSouls(sqlCommand);
            }

            return rval;
        } 

Aucun commentaire:

Enregistrer un commentaire