Count the number of 0s and 1s in a binary array.
Use the binary_array table. Count only valid binary values, excluding NULL entries.
bit and bit_count.bit.| Column | Type | Description |
|---|---|---|
| positionPK | INT | Position of the value in the binary array |
| bit | INT | Binary array value, expected to be 0 or 1 |