What is SQL ?

• SQL stands for Structure Query Language .

• It is a language used to communicate with database .

OPERATORS

1. ARITHIMETIC OPERATOR

2. CONCATINATION OPERATOR

3. COMPARISION OPERATOR

4. RELATION OPERATOR

5. LOGICAL OPERATOR

6. SPECIAL OPERATOR

7. SUB-QUERY OPERATOR

ARITHIMETIC OPERATOR

CONCATINATION OPERATOR

COMPARISION OPERATOR

• It is used to compare the values

RELATION OPERATOR

LOGICAL OPERATOR

• It is used to pass the multiple condition inside the WHERE clause .

• Types of Logical Operators.

• 1.AND

• 2.OR

• 3.NOT

AND OPERATOR

AND OPERATOR returns TRUE if both the condition are satishfy .

OR OPERATOR

OR OPERATOR returns true if any one of the condition satishify .

NOT OPERATOR

It is an inverse operator

SPECIAL OPERATOR

OR OPERATOR returns true if any one of the condition satishify

SUB-QUERY OPERATOR