Skip to main content

bitcount

1. BITCOUNT Function​

The BITCOUNT function in H2 database is used to calculate the number of bits set to 1 in a binary representation of a given number.

2. Syntax​

The syntax for the BITCOUNT function in H2 database is as follows:

BITCOUNT(number)

Arguments​

  • number: The number for which the bit count needs to be calculated. It should be a numeric value.

Return​

  • The BITCOUNT function returns the count of bits set to 1 in the binary representation of the given number.

3. Notes​

  • The BITCOUNT function in H2 database works with both signed and unsigned integers.
  • The input number can be of any numeric data type (e.g., INT, BIGINT, etc.).
  • If the input number is NULL, the BITCOUNT function will also return NULL.
  • The number is treated as an unsigned integer, so negative numbers will be converted to their corresponding positive binary representation before counting the bits.

4. Examples​

Here are a few examples demonstrating the usage of the BITCOUNT function in H2 database:

Example 1 - Counting the bits in a positive integer:​

SELECT BITCOUNT(10) AS bit_count;

Output:

bit_count
---------
2

Example 2 - Counting the bits in a negative integer:​

SELECT BITCOUNT(-10) AS bit_count;

Output:

bit_count
---------
30

Example 3 - Counting the bits in a column of numbers:​

CREATE TABLE numbers (
  id INT PRIMARY KEY,
  value INT
);

INSERT INTO numbers VALUES (1, 5), (2, 12), (3, 255);

SELECT id, value, BITCOUNT(value) AS bit_count
FROM numbers;

Output:

id | value | bit_count
---+-------+----------
1  | 5     | 2
2  | 12    | 2
3  | 255   | 8
  • bitand - Bitwise AND operation
  • bitor - Bitwise OR operation
  • bitxor - Bitwise XOR operation