BITCOUNT

BITCOUNT

Returns the number of bits that are set in the input expression.

Syntax

BIT_COUNT(expression)

Example

SELECT BITCOUNT(HEX_TO_BINARY('0x10'));

The above SQL returns:

BITCOUNT

----------------