Re: Undocumented SQL-Feature?

Posted in 1998

James Chapman — Thu, 25 Jun 1998 15:36:30 -0700 — source: Informix-list mailing list archive (1991-1998)

Martin Berns wrote: > > Hi, > try the following statement against stores7: > > select count(*) * 100/(select count(*) from cust_calls) percent > from cust_calls where call_code = 'I';> > Surprise (at least to me): it works! > Syntax say select-list may consist of ecpressions only and > a select-statement isn't an expression. > Am i missing something? > martin This is legitimate Entry Level SQL according to ANSI X3.135-1992 (aka SQL 92). A value expression can be a scalar subquery.