sum_if ​

Sum non-NULL values from rows whose condition is SQL true.

Syntax

sum_if(value, condition)

Arguments

value: numeric expression. condition: SQL truth expression. False and NULL conditions skip numeric accumulation; selected NULL values are ignored.

Returned value

The same numeric total and overflow behavior as sum; INTEGER 0 when no non-NULL selected value exists.

Examples

CREATE TABLE orders (amount INTEGER);
INSERT INTO orders VALUES (1),(NULL),(2);

SELECT sum_if(amount,amount > 1) FROM orders FORMAT csv;

2

• group_concat and string_agg

• any_value

• avg

• Aggregate combinators

• corr

• count

• covar_pop

• covar_samp

• array_agg

• bit_and

• bit_or

• bit_xor

• max

• min

• regr_avgx

• regr_avgy

• regr_count

• regr_intercept

• regr_r2

• regr_slope

• regr_sxx

• regr_sxy

• regr_syy

• stddev_pop

• stddev_samp

• sum

• var_pop

• var_samp