仅具有跳过(偏移)的SQLite(无限制) [英] SQLite with skip (offset) only (not limit)

问题描述

我正在尝试仅具有偏移量且没有限制的sql lite数据库.

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

但是当我有一个限制(LIMIT 10 OFFSET 10)时，我可以进行偏移查询.

I can do an offset query when I have a limit however (LIMIT 10 OFFSET 10).

这是sql lite给我的错误.

Here is the error sql lite is giving me.

SQLite error near "10": syntax error

推荐答案

只需将LIMIT设置为-1.

Just set LIMIT to -1.

例如:

SELECT * FROM table LIMIT -1 OFFSET 10

这篇关于仅具有跳过(偏移)的SQLite(无限制)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！