Functions/Numbers & math/bit_count

Numbers & math Scalar

bit_count()

Returns the number of bits that are set

Arguments & returns

6 overloads

`bit_count(x)`

Scalar

Overload link	`x`	Returns
#01	`BIGINT`	`TINYINT`
#02	`BIT`	`BIGINT`
#03	`HUGEINT`	`TINYINT`
#04	`INTEGER`	`TINYINT`
#05	`SMALLINT`	`TINYINT`
#06	`TINYINT`	`TINYINT`

Example

SELECT bit_count(31);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Apache Spark`bit_count()`

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3