BIT_
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