# 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

```sql
SELECT bit_count(8), bin(8);

```

```output

+--------------+--------+
| bit_count(8) | bin(8) |
+--------------+--------+
|            1 | 1000   |
+--------------+--------+

```

```sql
SELECT bit_count(1234), bin(1234);

```

```output

+-----------------+-------------+
| bit_count(1234) | bin(1234)   |
+-----------------+-------------+
|               5 | 10011010010 |
+-----------------+-------------+
```

```sql
SELECT bit_count(240), bin(240);

```

```output

+----------------+----------+
| bit_count(240) | bin(240) |
+----------------+----------+
|              4 | 11110000 |
+----------------+----------+
```

***

Modified at: February 24, 2023

Source: [/db/v9.1/reference/sql-reference/numeric-functions/bit-count/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/numeric-functions/bit-count/)

(An index of the documentation is available at /llms.txt)