TYPES OF OPERATOR IN SQL

1)LOGICAL OPERATOR

2)COMPARISION OPERATOR

3)RELATIONAL OPERATOR

4)CONCATINATION OPERATOR

5)ARTHIMATIC OPERATOR

6)SPECIAL OPERATOR

7)SUB-QUERIES OPERATOR

LOGICAL OPERATOR

logical operator are used perform logical operations on values

the operations are AND OR

SELECT ENAME,SAL FROM EMP

WHERE SAL<2000 AND SAL>5000;

SELECT ENAME,SAL FROM EMP

WHERE SAL<2000 AND SAL>5000;

ARTHIMATIC OPERATOR

arthimatic operator are used to perform arthimatical operaion on operands

ADDITION

Q:

SELECT SALARY+300 FROM EMP;

SUBTRACTION

Q:

SELECT SALARY-300 FROM EMP;

DIVISION

Q:

SELECT SALARY/300 FROM EMP;

MULTIPLICATION

Q:

SELECT SALARY*300 FROM EMP;