SQL Operator

Last Updated on May 16, 2018

Operator:

In SQL operator are reserved words or character used primarily to perform different operation such as arithmetic, comparison. The different types of operator are as Follows:

SQL Operator

1. Arithmetic Operator
2. Logical Operator
3. Comparision Operator

1. Arithmetic Operator

Arithmetic Operator includes Addition (+), Subtraction (-), Multiplication (*), Division (/) and Modulus (%)

2. Logical Operator

Logical Operator includes AND, OR, NOT, BETWEEN, EXISTS, IN, LIKE, IS NULL, UNIQUE

3. Comparision Operator

Comparision Operator includes Equals (=), Not equal (!= or <>), Less than (<), Greater than (>) , Less than or Equal to (<=), Greater than or equal to (>=), ,Is not Less than (!<), Is not Greater than (!>)