SQL Operators

Jump to bottom

Suja-dot edited this page Mar 16, 2021 · 1 revision

Logical Operators

AND, TRUE if both expressions are TRUE
OR, TRUE if either expression is TRUE
IN, TRUE if the operand is equal to one of a list of expression, the same result with single IN condition, instead of the multiple OR conditions
NOT IN, allows you to exclude a list of specific values form the result set
NOT, Returns TRUE if expression is not TRUE

Arithmetic Operators

'+', addition
'-', subtraction
'*', multiplication
'/', division