SQL查询Sum()问题 [英] SQL Query Sum() Problem

问题描述

我的C#Application中有一个SQLQuery

i have a SQLQuery in my C#Application

select sum(deductions) from Billing

当值存在时，它可以完美工作.
但是，当推导列包含 NULL 值时，我希望它应返回零(0).

请帮助我.

Its working perfectly when values are there.
But when deduction column contains NULL values then I want that it should return zero(0).

Please help me.

推荐答案

尝试 ^ ]

Try ISNULL function[^]

select sum(ISNULL(deductions,0)) from Billing

尝试:

SELECT SUM(ISNULL(deductions, 0)) FROM Billing

嘿，请使用以下代码:

Hey use below code:

select isnull(SUM(deductions),0) from Billing

这篇关于SQL查询Sum()问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！