Yes, thanks I understand now.
I take it there is no way to make it not return the field name.
RBS
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: 06 March 2007 19:53
To: SQLite
Subject: [sqlite] Re: What is wrong with this simple query (offset)?
RB Smissaert
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
2 matches
Mail list logo