AND (Lakehouse v1)

Conditional AND operator. Checks whether both conditions are true.

Analyze Syntax

and_(<expr1>[, <expr2> ...])

Analyze Examples

and_(
    table.color == 'green',
    table.shape == 'circle',
    table.price >= 1.25
)

SQL Syntax

<expr1> AND <expr2>

SQL Examples

SELECT * FROM table WHERE
    table.color = 'green'
    AND table.shape = 'circle'
    AND table.price >= 1.25;