SQL Operator
There are various types of SQL operator:
SQL Arithmetic Operators
Let's assume 'variable a' and 'variable b'. Here, 'a' contains 20 and 'b' contains 10.
Operator 
Description 
Example 
+ 
It adds the value of both operands. 
a+b will give 30 
 
It is used to subtract the righthand operand from the lefthand operand. 
ab will give 10 
* 
It is used to multiply the value of both operands. 
a*b will give 200 
/ 
It is used to divide the lefthand operand by the righthand operand. 
a/b will give 2 
% 
It is used to divide the lefthand operand by the righthand operand and returns reminder. 
a%b will give 0 
SQL Comparison Operators:
Let's assume 'variable a' and 'variable b'. Here, 'a' contains 20 and 'b' contains 10.
Operator 
Description 
Example 
= 
It checks if two operands values are equal or not, if the values are queal then condition becomes true. 
(a=b) is not true 
!= 
It checks if two operands values are equal or not, if values are not equal, then condition becomes true. 
(a!=b) is true 
<> 
It checks if two operands values are equal or not, if values are not equal then condition becomes true. 
(a<>b) is true 
> 
It checks if the left operand value is greater than right operand value, if yes then condition becomes true. 
(a>b) is not true 
< 
It checks if the left operand value is less than right operand value, if yes then condition becomes true. 
(a<b) is true 
>= 
It checks if the left operand value is greater than or equal to the right operand value, if yes then condition becomes true. 
(a>=b) is not true 
<= 
It checks if the left operand value is less than or equal to the right operand value, if yes then condition becomes true. 
(a<=b) is true 
!< 
It checks if the left operand value is not less than the right operand value, if yes then condition becomes true. 
(a!=b) is not true 
!> 
It checks if the left operand value is not greater than the right operand value, if yes then condition becomes true. 
(a!>b) is true 
SQL Logical Operators
There is the list of logical operator used in SQL:
Operator 
Description 
ALL 
It compares a value to all values in another value set. 
AND 
It allows the existence of multiple conditions in an SQL statement. 
ANY 
It compares the values in the list according to the condition. 
BETWEEN 
It is used to search for values that are within a set of values. 
IN 
It compares a value to that specified list value. 
NOT 
It reverses the meaning of any logical operator. 
OR 
It combines multiple conditions in SQL statements. 
EXISTS 
It is used to search for the presence of a row in a specified table. 
LIKE 
It compares a value to similar values using wildcard operator. 
