Skip to main content

SingleStoreDB v8.1

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 |
+----------------+----------+
In this section: