Subject Re: SUM
From Jerry Frost <ealer@comcast.net>
Date Sat, 13 Jan 2024 06:44:51 -0500
Newsgroups dbase.getting-started

Mervyn Bick Wrote:

> On 2024/01/11 15:31, Akshat Kapoor wrote:
>
> > Is there a possibility of null in the table. Null in even a single row
> > can give unexpected results.
>
> Both sum amount to x and select sum(amount)  ignore null values in the
> field.
>
> The most likely answer is that the sum is actually zero. :-)
>
> Mervyn.
>
>