BIT_
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
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.
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 |
+----------------+----------+Last modified: February 24, 2023