View Source

Returns true if both arguments evaluate to true. Equivalent to the && operator.

Each argument can be a literal Boolean, a function returning a Boolean, or a reference to a column containing Boolean values.

Since the AND function returns a Boolean value, it can be used as a function or a conditional.

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Logical Operators.

and(finalScoreEnglish >= 60, finalScoreMath >=60)

Output: Returns true if the values in the finalScoreEnglish and finalScoreMath columns are greater than or equal to 60. Otherwise, the value is false.

and(value1, value2)

Argument	Required?	Data Type	Description
value1	Y	string	The first value must be a Boolean literal, column reference, or expression that evaluates to `true` or `false`.
value2	Y	string	The first value must be a Boolean literal, column reference, or expression that evaluates to `true` or `false`.

value1, value2

Expressions, column references or literals to compare as Boolean values.

Missing or mismatched values generate missing results.

Required?	Data Type	Example Value
Yes	Function or column reference returning a Boolean value or Boolean literal	`myHeight > 2.00`

value1, value2

Example - Logical Functions