SingleStore Managed Service

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 |
+----------------+----------+