---
schema_version: "1"
id: 5b80f1aff058fb86b6e658aeb62d9316aaedc78e8cc50301628250b5ed2f6872
title: BIT_OR
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/aggregate-func/bit-or.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/bit-or.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: c34e14f35232342702957abd36f992cff2413b74eed731ad82f52ee8b7345368
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `BIT_OR`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Computes the bitwise `OR` of all non-null input values.

## Syntax

```sql
bit_or(<expression>)
```

## Arguments

### Required

- `<expression>`: An expression of an integral type.

## Returns

Returns the same type as the argument. Returns NULL if no non-null input values exist.

## Considerations

- NULL values are ignored in the calculation.
- Returns NULL when all input values are NULL or the set is empty.
- Useful for combining flags or checking if any bit is set across values.

## Examples

### Bitwise `OR` of Values

Compute the bitwise `OR` of a column.

```sql
SELECT bit_or(permissions) AS all_permissions
FROM user_roles;
```

### Combine Flags

Combine all flags from a group.

```sql
SELECT user_id, bit_or(feature_flags) AS enabled_features
FROM user_settings
GROUP BY user_id;
```

## Related Documentation

- [BIT_AND](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/bit-and.md)
- [Aggregate Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/aggregate.md)