RE: Aggregates in Queries

For one thing in your particular example sum(max(sal)) and max(sal) are identical. Max returns one record, if you sum one record you get that same record. } -----Original Message----- } From: S SATHISH-SI [SMTP:ssathish@getafix.cmc.net.in] } Sent: Wednesday, October 15, 1997 9:15 AM } To: informix-list@rmy.emory.edu } Subject: Aggregates in Queries } } 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? } Bye } } ********************************************************************** } ******** } S.Sathish } email :ssathish@cmcbang.ernet.in } ********************************************************************** } ******** }