Re: Aggregates in Queries

Posted in 1997

Art S. Kagel — Tue, 21 Oct 1997 17:21:22 -0400 — source: Informix-list mailing list archive (1991-1998)

S SATHISH-SI wrote: > > Hi, > Why does Online 7.1 disallow nesting aggregates in queries. > eg., > Select sum(max(sal)) from emp where ... group by ... > In case i want the sum of the maximum salaries in a department without > writing a subquery? Three word reply: Use temp table Art S. Kagel