Sqlite With Skip (offset) Only (not Limit)

I am trying to query a sql lite database with only an offset and no limit. SELECT [Id], [Name], [IntValue], [IntNulableValue] FROM [Product] OFFSET 10 I can do an offset query whe

Solution 1:

Just set LIMIT to -1.

For example:

SELECT*FROMtable LIMIT -1OFFSET10

Solution 2:

On the SQL as understood by SQLite page, you'll notice that OFFSET isn't understood without LIMIT.

http://sqlite.org/lang_select.html

According to the same documentation:

If the LIMIT expression evaluates to a negative value, then there is no upper bound on the number of rows returned.