Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

6.1 KiB

Raw Permalink Blame History

factorial

This function is used to return the factorial of a.

Syntax

factorial(INT a)

Parameters

**Table 1** Parameter
Parameter	Mandatory	Type	Description
a	Yes	BIGINT, INT, SMALLINT, or TINYINT	The value is an integer. If the value is not of the INT type, the system will implicitly convert it to the INT type for calculation. The string is converted to its corresponding ASCII code.

Return Values

The return value is of the BIGINT type.

If the value of a is 0, 1 is returned.
If the value of a is NULL or outside the range of [0,20], NULL is returned.

Example Code

The value 720 is returned.

select factorial(6);

The value 1 is returned.

select factorial(1);

The value 120 is returned.

select factorial(5.123456);

The value NULL is returned.

select factorial(null);