|<
<
27
>
>|
Aggregation
Sum
The
sum
function can be used to sum columns.
Same rules as for counting values:
sum(x)
sums non-null values of x.
sum(distinct x)
sums distinct non-null values of x.
Data
select
sum(x)
from t
15
select
sum(distinct x)
from t
10
|<
<
27
>
>|