BIT_COUNT

​

Syntax

​

Scalar

bit_count(value)

​

Arguments

​

Returns

• Type: INT
• Possible values: An integer from 0 through 64.
• NULL behavior: Returns NULL when an argument is NULL.

​

Properties

​

Usage notes

• Signed inputs are sign-extended to 64 bits before counting; negative TINYINT, SMALLINT and INT operands therefore count the 64-bit representation.
• Use the numeric input types listed above. BOOLEAN is not a supported SQL input.

​

Examples

​

Set bits and signed representation

SELECT bit_count(7) AS bits, bit_count(CAST(-1 AS BIGINT)) AS signed_bits, bit_count(CAST(NULL AS BIGINT)) AS null_value;

​

Zero and positive integers

SELECT bit_count(CAST(0 AS INT)) AS no_set_bits, bit_count(CAST(15 AS INT)) AS four_set_bits;