<div>
Perfect. &nbsp;Thanks for the explanation. &nbsp;Makes total sense.
</div>


<div>
&gt;For the below code why would the result return 1 row and a value of Null for SUM ?<br />
As Richard states above now rows are found, and think of it this way: &nbsp;NULL means there no rows found, and zero means rows were found and the average is zero. &nbsp;These are two completely different answers, which could have erroneous downstream impacts if a zero is passed.
</div>


<div>
<div class="content wysiwyg-content">
For the below code why would the result return 1 row and a value of Null for SUM ? &nbsp;In my case StockID 25 does not exist so &nbsp;my assumption is that no rows would &nbsp;be found ? &nbsp;Why is 1 row returned ?<br />
<br />
<br />
Select<br />
&nbsp;SUM(Interest) As Total<br />
From<br />
Table Stocks<br />
WHERE<br />
StockID = 25
</div>
</div>


For the below code why would the result return 1 row and a value of Null for SUM ?  In my case StockID 25 does not exist so  my assumption is that no rows would  be found ?  Why is 1 row returned ?


Select
 SUM(Interest) As Total
From
Table Stocks
WHERE
StockID = 25

Why is Null the result for a Sum calculation on a record not found

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.