Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/functions/booland below:

Website Navigation

• Reference
• Function and stored procedure reference
• Conditional expression

BOOLAND | Snowflake Documentation

Categories:

Conditional expression functions

Computes the Boolean AND of two numeric expressions. In accordance with Boolean semantics:

• Non-zero values (including negative numbers) are regarded as True.

• Zero values are regarded as False.

As a result, the function returns:

• True if both expressions are non-zero.

• False if both expressions are zero or one expression is zero and the other expression is non-zero or NULL.

• NULL if both expressions are NULL or one expression is NULL and the other expression is non-zero.

See also:

BOOLNOT , BOOLOR , BOOLXOR

SELECT BOOLAND(1, -2), BOOLAND(0, 2.35), BOOLAND(0, 0), BOOLAND(0, NULL), BOOLAND(NULL, 3), BOOLAND(NULL, NULL);

+----------------+------------------+---------------+------------------+------------------+---------------------+
| BOOLAND(1, -2) | BOOLAND(0, 2.35) | BOOLAND(0, 0) | BOOLAND(0, NULL) | BOOLAND(NULL, 3) | BOOLAND(NULL, NULL) |
|----------------+------------------+---------------+------------------+------------------+---------------------|
| True           | False            | False         | False            | NULL             | NULL                |
+----------------+------------------+---------------+------------------+------------------+---------------------+

Copy

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4