Operators in SQL

 Operators

There are five operators in SQL

1. Arithmetic Operator(+   -   *  / )
2. Logical Operator ( AND , OR , NOT)
3. Relational Operator ( < , > , <= , >= )
4. Assignment Operator (= , != , < > )
5. Concatenation Operator( || ) pipe operator

Special Operators 

1. IN
2. NOT IN
3. IS
4. NOT IS
5. LIKE
6. NOT LIKE
7. BETWEEN
8. NOT BETWEEN

Subquery operators

1. ALL
2. ANY
3. EXISTS
4. NOT EXISTS

1.Arithmatical Operator -It is use to perform mathematical operations on numerical data such as addition or subtraction.

1. Addition (+)
2. Subtraction (-)
3. Multiplication (*)
4. Division ( / )

1)Addition (+) - The + symbol use to add tow or more number together.

SELECT 8+8;

2) Subtraction (-) - The - symbol use to subtract one number to another number.

SELECT 8-8;

3)Multiplication ( * )- The * symbol use to multiply the two number together.

SELECT  8*8; 

4)Division ( / )- The / symbol use to divide one number to another number.

SELECT 8/8;