Division by Zero

huwjeffries · **Joined:** Fri Nov 27, 2009 8:40 am **Posts:** 1

Hi There,

I'm writing a HQL query that basically says:

Select poco.A, sum(poco.B) / sum(poco.C) from Poco poco
group by poco.A
order by sum(poco.B) / sum(poco.C);

The problem is that if some groups of records have zero values for Sum(C), then we get a divide by zero error. How could I work round this in HQL?

I know I could manually do the division once I've got the results, but there are several million records and I only need the top 20, hence the "Order By" clause (along with SetMaxResults(20) used later).

Any help would be much appreciated!

Thanks,

Huw

don stevo · **Joined:** Mon Aug 07, 2006 5:07 am **Posts:** 56

Don't know for sure, but can't you do something like this in HQL?

Code:

Select poco.A, sum(poco.B) / sum(poco.C) from Poco poco
group by poco.A
having sum(poco.C) != 0
order by sum(poco.B) / sum(poco.C);

Let me know ... :-)

stolley · **Posted:** Mon Nov 30, 2009 9:50 am

Quote:

How could I work round this in HQL?

How would you get around it in SQL?