In this article we will learn different types of operators in SQL. These operators are used with SQL select statement or SQL clause to get the required output.

__What is an operator__?

- An operator is used to limit the number of row in result set.
- Commonly used SQL operator are given below:
- Arithmetic Operator
- Comparison Operator
- Logical Operator

__Let’s discuss the use of each operator in detail__:

**Arithmetic Operator:**- Arithmetic operator used to perform mathematical operations.
- It must be used with numbers (integer, float and double)
__Let’s have a look at the following salary table__:- On this salary table, we are going to perform addition operation and subtraction operation for calculating a salary.
- Similarly, you can perform other arithmetic operations with the available arithmetic operator’s to manipulate the result set.
**Comparison Operator:**- These operators are used to compare data in column to the data specified in SQL statement.
- The comparison operators should be used with where clause.
- It limits the result set specified by particular comparison operator.
__Let’s understand the uses of these operators in the following example, where we will use one of the comparison operator to manipulate the data in salary table__:**Logical Operator:****AND**,**OR**,**NOT**are the three types of logical operators.- It populate’s the result only If the condition is true.
- It result’s into boolean data type, if condition is true then it populates the result set like comparison operator.
__Let see the implementation of one of the logical operator with salary table__:- Similarly, you can implement other logical operators to manipulate the data.

__Basic formula for calculating salary__:

1 |
(Basic pay + Allowances) - (Deduction) |

__Query__:

1 |
select empname, (House_Allowance + Water_Allowance + Electric_Allowance + Basic_pay) - (Lic_Ded+I_Tax+Other_ded) as salary from salary |

__Query__: To get the employee whose basic pay is more than 3000
1 |
select empname,Basic_pay from salary where Basic_pay >3000 |

__Query__: To get salary of employee whose basic pay is between 2000 to 5000 using AND operator.
1 |
select empname,Basic_pay from salary where Basic_pay >=2000 and Basic_pay <=5000 |

Hence, we successfully learnt about different types of operators that are used in SQL along with their implementations.