<

SQL Different Types of Operator

SQL operators are:Arithmetic Operator,Comparison Operator and Logical Operator.


SQL Arithmetic Operators

  • + Add

  • - Subtract

  • * Multiply

  • / Divide

  • % Modulo



  • SQL Comparison Operators



  • += Add equals

  • -= Subtract equals

  • *= Multiply equals

  • /= Divide equals

  • %= Modulo equals

  • &= Bitwise AND equals

  • ^-= Bitwise exclusive equals

  • |*= Bitwise OR equals



  • SQL Logical Operators



  • 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
















  • © copyright 2017-2022 Completedone pvt ltd.