Re: Undocumented SQL-Feature?

Posted in 1998

Art S. Kagel — Thu, 25 Jun 1998 15:39:57 -0400 — 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? Yes a SELECT that returns a single value is indeed an expression in this syntax. Art S. Kagel