FACTORIAL

​

Syntax

​

Integer (scalar)

factorial(value)

​

Arguments

​

Returns

• Type: BIGINT
• Possible values: 1 through 2432902008176640000 for supported integer inputs.
• NULL behavior: NULL input or an input outside 0 through 20 returns NULL. factorial(0) is 1.

​

Properties

​

Usage notes

• Numeric input is converted to BIGINT. Use an explicit BIGINT cast when the conversion affects your result.

​

Examples

​

Basic call

SELECT factorial(5) AS result;

​

Zero and upper boundary

SELECT factorial(0) AS zero_value, factorial(20) AS upper_value;

​

NULL and out-of-range inputs

SELECT factorial(CAST(NULL AS BIGINT)) AS null_value, factorial(-1) AS negative_value, factorial(21) AS overflow_value;

​

Limitations

• Only the factorials of integers from 0 through 20 fit the supported range. Negative inputs and values above 20 produce NULL.