Subject Re: SUM From Mervyn Bick <invalid@invalid.invalid> Date Thu, 11 Jan 2024 15:46:47 +0200 Newsgroups dbase.getting-started 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.