I am using hibernate 2.x in windows.

need to select a count(*) From table t WHERE (sum(t.a) + sum(t.b) + sum(t.c)) > 0

is that possible?

thanx

I did something similar with Hibernate 3.2 which worked:

select sum(t.a), sum(t.b), sum(t.c), t.d From table t GROUP BY t.d HAVING (sum(t.a) + sum(t.b) + sum(t.c)) > 0

You probably just need to change your WHERE clause to a HAVING clause, otherwise you may get an exception: 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.

select count(*) from table t where (t.a + t.b + t.c) > 0

worked.

now what about select sum(t.a) + sum(t.b) + sum(t.c)....hopefully can find a way to get that gong...

edit: ya

select sum(t.a + t.b + t.c) from table t where (t.a + t.b + t.c) > 0

that was alot of worrying for nothing....