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; -- or select * from tableName limit 5, -1
Also what is mentioned on website is different from what is there in parser.c file. On website Limit and offset is followed by integer whereas in parser.c it's followed by an expression.
An expression is allowed. I use a query that has a subselect in the LIMIT clause (I need to return, say, top 10% of all the records).
How does the "Limit 10, 30" works? Is this same as "limit 10, offset 30"?
No, it's "limit 30 offset 10". This is explained at http://sqlite.org/lang_select.html Igor Tandetnik ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------