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