SELECT SUM(NVL(a,0)) FROM abc_file // 结果: NULL
SELECT NVL(SUM(a),0) FROM abc_file // 结果: 0
SELECT NVL(SUM(NVL(a,0)),0) FROM abc_file // 结果: 0
总结:对于不能为空的字段,用NVL(SUM(a),0)
SELECT SUM(NVL(a,0)) FROM abc_file // 结果: NULL
SELECT NVL(SUM(a),0) FROM abc_file // 结果: 0
SELECT NVL(SUM(NVL(a,0)),0) FROM abc_file // 结果: 0
总结:对于不能为空的字段,用NVL(SUM(a),0)