Aakansha
Member since May 2, 2010
- Profile: /members/5951-aakansha.htm
- Comments: 1
Recent Blog Comments By Aakansha
-
Using NULLIF() To Prevent Divide-By-Zero Errors In SQL
Posted on May 2, 2010 at 1:36 AM
Hi, Excellent find! Using this I soved my problem. For e.g sum(objid)/nullif(count(units_purch),0) where count(units_purch) return 0 value. However I've one question can I solve this problem using CASE statement. If yes, then how? Thanks in advance! Regards, Aakansha... read more »