Use the case statement to exclude the SQL statement with a denominator of 0.

An SQL statement is used in the project, such:

Select sum (price * xiaoliang)/sum (xiaoliang) price from ......

When sum (xiaoliang) = 0, the error of division by 0 will occur. What should I do? At first, I wantProgramProcessing, that is, moving the computing process to the program is obviously troublesome. Later, I found the method of using the case statement as follows:

Select (Case sum (xiaoliang) When 0 then 0 else sum (price * xiaoliang)/sum (xiaoliang) End) price from ......

This parameter is used to determine the sum (xiaoliang) value. If it is 0, the price value is set to 0. Otherwise, the value is calculated based on the formula.