請問： select A as 開單數, B as 結案數, C as 作廢單數, B/(A-C) as 達成率 from TableM 若 B=0 且 (A-C)=0 時會發生除以零錯誤 我想要若B=0 且 (A-C)=0時，達成率就顯示0 請問這sql語法要如何寫，謝謝。

Hi tomcheng,    SQL Server :

select  A as 開單數, 
        B as 結案數, 
        C as 作廢單數,
        case when (A-C)  = 0 then 0 
        else  B/(A-C) 
        end as 達成率
from    TableM

Oracle :

select  A as 開單數, 
        B as 結案數, 
        C as 作廢單數,
        decode((A-C),0,0,B/(A-C)) as 達成率
from    TableM

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman

select A as 開單數, B as 結案數, C as 作廢單數, iif(a-c=0,0,B/(A-C)) as 達成率 from TableM

感謝兩位的解答， 分數只能給一位，只好給先回答的， shinhrn抱歉了.