B V, Phanisekhar wrote:
Can we have the following statement?
Select * from tableName offset 3
I believe the above query is supported by SQL; but it's not supported by
Sqlite.
The limit and offset clauses are not part of the SQL standard. They are
commonly implemented extensions that vary fr
>> Why Sqlite doesn't support just the use of offset in select
>> statements? As such SQL does support the use of offset only, without
>> limit. But in case of Sqlite it's not possible to use offset without
>> limit.
>select * from tableName limit -1 offset 5;
>-- or
>select * from tableName limit
2 matches
Mail list logo