;

SQL Operators

In this tutorial, we will learn about operators used in SQL.

SQL Operators

What are Operators in SQL?

SQL Operators is a reserved word or a character used in SQL statements to perform operations such as comparisons and arithmetic operations.

Generally, There is 3 type of operator in SQL as follow:

  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators

SQL Arithmetic Operators:

Let's assume two variables "a" and "b", Variable "a" hold value 100 and variable "b" hold value 50.

Operator Description Example
+ Add - it is used to perform addition. a+b will give 150
- Subtract - it is used to perform subtraction. a-b will give 50
* Multiply - it used to perform multiplication. a*b will give 5000
/ Divide - it is used to perform division a/b will give 2
% Modulus - it is used to return a remainder. a%2 will give 0

SQL Comparison Operators:

Let's assume two variables "a" and "b", Variable "a" hold value 100 and variable "b" hold value 50.

Operator Description Example
= It is used to compare two operands are equal or not.if yes then condition becomes true. (a=b) is not true
> It is used to check that left operand is greater than right operand or not.if yes then condition becomes true. (a > b) is true
< It is used to check that left operand is less than right operand or not.if yes then condition becomes true. (a < b) is false
>= It is used to check that left operand is greater than or equal to right operand or not.if yes then condition becomes true. (a >= b) is true
<= It is used to check that left operand is less than or equal to right operand or not.if yes then condition becomes true. (a <= b) is true
<> It is used to check that left operand is not equal to right operand or not.if yes then condition becomes true. (a<>b) is true
!= It is used to check that left operand is not equal to right operand or not.if yes then condition becomes true. (a!=b) is true
!< It is used to check that left operand is not less than right operand or not.if yes then condition becomes true. (a!<b) is true
!> It is used to check that left operand is not greater than right operand or not.if yes then condition becomes true. (a !> b) is false

SQL LOGICAL Operators:

Operator Description
ALL ALL operator returns TRUE if all of the subquery values meet the condition.
AND AND operator returns TRUE if all the conditions separated by AND is TRUE.
ANY ANY operator returns TRUE if any of the subquery values meet the condition.
BETWEEN BETWEEN operator display records if the operand is within the range of comparisons.
EXISTS EXISTS operator returns TRUE if the subquery returns one or more records.
IN IN operator returns TRUE if the operand is equal to one of a list of expressions.
LIKE LIKE Operator returns TRUE if the operand matches a pattern using wildcard operators.
NOT NOT operator displays a record if the condition(s) is NOT TRUE.
OR OR operator returns TRUE if any of the conditions separated by OR is TRUE.
SOME SOME operator returns TRUE if any of the subquery values meet the condition.