Reference Guide > TDV Support for SQL Operators > Arithmetic Operators > Factorial
 
Factorial
Factorial is an operator ( ! ) and a function (FACTORIAL) that returns the factorial product of an integer.
Note: Twenty-factorial (20! or 2.432902e+18) is the largest factorial product that TDV natively supports. It is 9.223372e+18, which is within the range of BIGINT (-2**63 to +2**63 - 1). For maximum values in pushed functions, refer to the appropriate section of Function Support for Data Sources
Syntax
operand !
FACTORIAL(n)
Examples
FACTORIAL(5)
5!
 
Both of these return 120 (1 * 2 * 3 * 4 * 5).