Re: [sqlite] offset of SQL query fail.

"Kei" <[EMAIL PROTECTED]> writes: > sqlite> select * from tbl offset 4 limit 5; > SQL error: near "4": syntax error > > Is the SQL query wrong ?what is the correct SQL query if it is wrong? The correct syntax has limit first, offset next: sqlite> select * from tbl limit 5 offset 4; Derrell ---

[sqlite] offset of SQL query fail.

Hi all, I am using sqlite ver 2.8.12. and I want to do the SQL statement with offset and limit: but the error occurs at the offset sqlite> select * from tbl offset 4 limit 5; SQL error: near "4": syntax error Is the SQL query wrong ?what is the correct SQL query if it is wrong? thx all! Best