Operator | Description | |
---|---|---|
ALL | TRUE if all of the subquery values meet the condition | |
AND | TRUE if all the conditions separated by AND is TRUE | |
ANY | TRUE if any of the subquery values meet the condition | |
BETWEEN | TRUE if the operand is within the range of comparisons | |
EXISTS | TRUE if the subquery returns one or more records | |
IN | TRUE if the operand is equal to one of a list of expressions | |
LIKE | TRUE if the operand matches a pattern | |
NOT | Displays a record if the condition(s) is NOT TRUE | |
OR | TRUE if any of the conditions separated by OR is TRUE | |
SOME | TRUE if any of the subquery values meet the condition |
Practice Excercise Practice now