Returns a count of the number of bits set to 1 (TRUE) in the array.
COUNT_SET_BITS( bit-expression )
bit-expression The bit array for which to determine the set bits.
UNSIGNED INT
Returns NULL if bit-expression is NULL.
SQL/2008 Vendor extension.
The following statement returns the value 4:
SELECT COUNT_SET_BITS( '00110011' );
The following statement returns the value 12:
SELECT COUNT_SET_BITS( '0011001111111111' );