BIT_COUNT()

All functions > BITWISE > BIT_COUNT()

Returns the number of 1-bits in the two’s-complement binary representation of an integer.

Signatures

Integer popcount

Returns: Number of bits set to 1

BIT_COUNT(value: T) → BIGINT

With:

• T : Integer type (TINYINT … BIGINT)

Signature notes:

• Returns NULL if the input is NULL
• Interprets the value as a signed integer in two’s-complement form

Examples

SELECT
    -- No bits set
    f1 := BIT_COUNT(0),
    -- Binary 111
    f2 := BIT_COUNT(7),
    -- All bits set in 64-bit representation
    f3 := BIT_COUNT(-1)
;