db2level:db2v8.1 fixpack4
查询语句:
SELECT CASE num WHEN 0 THEN 0 ELSE money / num END
FROM TABLE(
VALUES (10, 0)
) AS t(money, num)
@
执行时,报错:“尝试用0做除数”。
稍微修改下,如下
SELECT CASE num WHEN 0 THEN 0 ELSE money / num END
FROM TABLE(
VALUES (10, 0),
(10, 0),
(10, 0)
) AS t(money, num)
@
执行成功!