----- Original Message -----
From: "RB Smissaert" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, March 06, 2007 1:39 PM
Subject: [sqlite] What is wrong with this simple query (offset)?
Why does this query give a syntax error near offset?
SELECT
Name
FROM SQLITE_MASTER
WHERE TYPE = 'table'
ORDER BY 1 ASC
offset 2
limit works fine.
Though I've never used OFFSET, the documentation seems to state that
OFFSET is an *optional* component of the LIMIT clause. So, I'd guess
you can't use it without also using LIMIT.
Jeff
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
