RB Smissaert <[EMAIL PROTECTED]>
wrote:
Why does this query give a syntax error near offset?
SELECT
Name
FROM SQLITE_MASTER
WHERE TYPE = 'table'
ORDER BY 1 ASC
offset 2
The syntax doesn't allow OFFSET on its own, but only together with
LIMIT. Make it
LIMIT -1 OFFSET 2
-- or
LIMIT 2, -1
-1 means no limit.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
