SQL Operators – Tutorialpath

What is an Operator in SQL?

An operator may be a reserved word or a character used primarily in AN SQL statement’s wherever clause to perform an operation(s), equivalent to comparisons and arithmetic operations.

  • Arithmetic operators
  • Comparison operators
  • Logical operators
  • Operators used to negate conditions

A. Arithmetic operators

  • + (Addition) – This SQL operator adds values on either side of the operator
  • – (Subtraction) – This SQL operator subtracts right-hand operand from left-hand operand.
  • * (Multiplication) – This SQL operator multiplies values on either side of the operator.
  • / (Division) – This SQL operator divides mitt operand by right-hand operand.
  • % (Modulus) – This operator divides the left-hand operand by the right-hand operand and returns the remainder.

B. Comparison operators

  • = – This SQL operator checks if the values of 2 operands area unit equal or not, if yes then condition becomes true.
  • != – This SQL operator checks if the values of 2 operands area unit equal or not if values aren’t equal then condition becomes true.
  • <> – This operator checks if the values of 2 operands area unit equal or not, if values aren’t equal then condition becomes true.
  • > – This operator checks if the value of the left quantity is larger than the worth of right quantity, if yes then condition becomes true.
  • < – This operator checks if the worth of the left operand is a smaller amount than the value of right quantity, if yes then condition becomes true.
  • >= – This operator checks if the worth of left operand is larger than or up to the worth of right operand, if yes then condition becomes true.
  • <= – This operator checks if the worth of left operand is less than or up to the value of right operand, if yes then condition becomes true.
  • !< – This operator checks if the value of left operand isn’t below the value of right operand, if yes then condition becomes true.
  • !> – This operator checks if the value of left operand isn’t larger than the value of right operand, if yes then condition becomes true.

C. Logical operators:

  • ALL – The ALL operator employes to match to any or all values in another value set.
  • AND – The AND operator permits the existence of multiple conditions in an SQL statement’s wherever clause.
  • ANY – The ANY operator uses to match to any applicable value within the list as per the condition.
  • BETWEEN – The BETWEEN operator uses to search for values that area unit within a set of values, given the minimum price and therefore the maximum value.
  • EXISTS – The EXISTS operator uses to go looking for the presence of a row in an exceedingly specified table that meets a particular criterion.
  • IN – The IN operator uses to match a value to a list of literal values that are such.
  • LIKE – The LIKE operator uses to match a value to similar values using wildcard operators.
  • NOT – The NOT operator reverses the means of the logical operator with that we use it. E.g.: NOT EXISTS, NOT BETWEEN, NOT IN, etc. this is often a negate operator.
  • OR – The OR operator uses to mix multiple conditions in an SQL statement’s wherever clause.
  • IS NULL – The NULL operator uses to match a with a NULL value.
  • UNIQUE – The unique operator searches each row of a table for uniqueness (no duplicates).

So, this was all in SQL Operators. Hope you like our explanation.

Note: In this SQL Operators tutorial, we discussed 3 main operators in SQL. These SQL Operators are arithmetic, comparison, and logical operators. Still, if any query regarding SQL Operators, ask in the comment tab.

Leave a Reply

Your email address will not be published. Required fields are marked *