How to set where condition for aggregate function.

Question

select SUM (dbo.GLAFS.OPENBAL) + SUM (dbo.GLAFS.NETPERD1) AS January from GLAFS where SUM (dbo.GLAFS.OPENBAL) + SUM (dbo.GLAFS.NETPERD1) > 0 its giving an error  An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list and the column being aggregated is an outer reference How can i resolve this issue. Please help.

Puneet Kankar · Answer

SELECT * FROM table1 WHERE EXISTS( SELECT s1.Ecodes2.EcodeSUM(s1.duration) AS 'SumA'SUM(s2.duration) AS 'SumB' FROM table1 s1 INNER JOIN table2 s2 ON s1.Ecode=s2.Ecode GROUP BY s1.Ecodes2.Ecode HAVING SUM(s1.duration)!=SUM(s2.duration)AND (s1.Ecode=s2.Ecode))

Mitesh Gadhiya · Answer

select SUM (dbo.GLAFS.OPENBAL) + SUM (dbo.GLAFS.NETPERD1) AS January from GLAFS Having SUM (dbo.GLAFS.OPENBAL) + SUM (dbo.GLAFS.NETPERD1) > 0

Rajkiran Swain · Answer

https://stackoverflow.com/questions/4662955/where-clause-condition-on-aggregate-functions

Rafnas T P · Answer

ya you can not give aggregation in where condition instead of you can use Having clause