Name
sum() — Return the numerical summation
Common Usage
sum( number
)
Description
The sum()
aggregate computes the sum or total of
all the non-NULL
values. Any non-NULL number
that is not an integer will be interpreted as a
floating-point value.number
If all non-NULL
values are integers, number
sum()
will return an integer. Otherwise,
sum()
will return a
floating-point value. If no non-NULL
is found, number
sum()
will return NULL.
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.