Thanks Igor & Dennis, > As far as I can tell, LIMIT and OFFSET clauses are not specified in any > version of SQL standard. What is your belief based on that this query is > supported by SQL, and what precisely do you mean by the term "SQL" in > this assertion?
I thought limit and offset are part of SQL standard language; which actually is not correct. > select * from tableName order by someField DESC > limit ROUND( (select count(*) from tableName) / 10); "limit_opt ::=", "limit_opt ::= LIMIT expr", "limit_opt ::= LIMIT expr OFFSET expr", "limit_opt ::= LIMIT expr COMMA expr", Which one of the above four will allow the above statement to pass through? I didn't find "ROUND" in parser.c file. Regards, Phanisekhar ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
