IN Operator

Matches any value in a subquery or a specified list.

IN Operator Example

NOT IN Operator

Excludes values that match any value in a subquery or list.

NOT IN Operator Example

EXISTS Operator

Returns true if the subquery returns one or more records.

EXISTS Operator Example

NOT EXISTS Operator

Returns true if the subquery returns no records.

NOT EXISTS Operator Example

ALL Operator

Compares a value to every value in a result set returned by a subquery.

ALL Operator Example

ANY Operator

Compares a value to each value in a result set and returns true if any match.

ANY Operator Example