I am using sqlite version 3.3.7 Also what I have noticed is "limit ALL" is not supported.
"limit_opt ::=", "limit_opt ::= LIMIT expr", "limit_opt ::= LIMIT expr OFFSET expr", "limit_opt ::= LIMIT expr COMMA expr", expr doesn't contain "ALL". ------------------------------------------------------------ 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. 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. How does the "Limit 10, 30" works? Is this same as "limit 10, offset 30"? ------------------------------------------------------------ Regards, Phani ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
