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
B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
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;
--
B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
Also what I have noticed is "limit ALL" is not supported.
A negative value is interpreted as ALL. This is also documented at
http://sqlite.org/lang_select.html
Igor Tandetnik
-
4 matches
Mail list logo