Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
BIT_COUNT
Given a number, return the number of ones in its binary representation.
Syntax
BIT_COUNT ( expression )
Arguments
- expression: any valid numeric expression.
Return Type
The number of ones bits in the binary representation. Float values are truncated. Returns NULL if expression is NULL.
Examples
SELECT bit_count(8), bin(8);
+--------------+--------+
| bit_count(8) | bin(8) |
+--------------+--------+
| 1 | 1000 |
+--------------+--------+
SELECT bit_count(1234), bin(1234);
+-----------------+-------------+
| bit_count(1234) | bin(1234) |
+-----------------+-------------+
| 5 | 10011010010 |
+-----------------+-------------+
SELECT bit_count(240), bin(240);
+----------------+----------+
| bit_count(240) | bin(240) |
+----------------+----------+
| 4 | 11110000 |
+----------------+----------+
