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]
-----------------------------------------------------------------------------

Reply via email to