CODEWITHSUNDEEP
sqliteoffset
Paul Knopf
Paul Knopf

Reputation: 9786

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 when I have a limit however (LIMIT 10 OFFSET 10).

Here is the error sql lite is giving me.

SQLite error near "10": syntax error

Upvotes: 35

Views: 21209

Answers (2)

Mark Paine
Mark Paine

Reputation: 1894

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.

Upvotes: 13

Ming-Hong Bai
Ming-Hong Bai

Reputation: 875

Just set LIMIT to -1.

For example:

SELECT * FROM table LIMIT -1 OFFSET 10

Upvotes: 76

Related Questions