---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/logical.md
cuppy_section: docs
cuppy_doc: 9A0N-83Y8
cuppy_doc_uuid: dda3f415-3735-4bb3-9adc-7421b84291ba
cuppy_permalink: https://cuppy.io/salesforce/d/9A0N-83Y8
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/logical
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 2c8ea077593ec848c515d93303cb73cb34dd42f9f31780ddaf26d028df9a8545
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/logical.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

# Logical Operators

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

These are the logical operators for boolean values:`AND`, `OR`, `NOT`. SQL uses a three-valued logic system with true, false, and `null`, which represents “unknown”.

| `a` | `b` | `a AND b` | `a OR b` |
| :--- | :--- | :--- | :--- |
| TRUE | TRUE | TRUE | TRUE |
| TRUE | FALSE | FALSE | TRUE |
| TRUE | NULL | NULL | TRUE |
| FALSE | FALSE | FALSE | FALSE |
| FALSE | NULL | FALSE | NULL |
| NULL | NULL | NULL | NULL |

| `a` | `NOT a` |
| :--- | :--- |
| TRUE | FALSE |
| FALSE | TRUE |
| NULL | NULL |

The operators `AND` and `OR` are commutative, that is, you can switch the left and right operand without affecting the result.

![Image 1: Salesforce](https://a.sfdcstatic.com/digital/one-trust/core/stable/consent/8e783e8c-0ad0-475d-8fca-4a03afa0a02a/019e3ba8-766d-7090-bf0d-c2f7beefa22d/logos/ddb906c9-f57b-40fc-85a1-c8bcbc371b0d/6a33a761-886e-4860-8e17-abc0832f7a62/corporate_logo_big.png)

## Cookie Consent Manager

## Cookie Consent Manager

*   ### General Information 
*   ### Required Cookies 
*   ### Functional Cookies 
*   ### Advertising Cookies 

#### General Information

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.   
[Privacy Statement](https://www.salesforce.com/company/privacy/full_privacy/)

#### Required Cookies

Always Active

Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.

Cookies Details

#### Functional Cookies

- [x] Functional Cookies 

Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.

Cookies Details

#### Advertising Cookies

- [x] Advertising Cookies 

Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.

Cookies Details

### Cookie List

Consent Leg.Interest

- [x] checkbox label label

- [x] checkbox label label

- [x] checkbox label label

Clear

*   - [x] checkbox label label 

Apply Cancel

Save Settings

Accept All Cookies

[![Image 2: Powered by Onetrust](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/logical.html)](https://onetrust.com/poweredbyonetrust)


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->