# Operators in SQL

## Operators in SQL

Operator is a special symbols which perform some operation on operands. In SQL all operators are classified into following types;

• Arithmetic Operators
• Relational Operators
• Logical Operators
• Miscellaneous Operators

## Arithmetic Operators

OperatorNameExample (int a=8, b=3)
-Subtractiona-b=5
*Multiplicationa*b=24
/Divisiona/b=2
%Modulas (Remainder)a%4=0

## Relational Operators

OperatorsDescriptionExample: a=10, b=20
=Check both operands value that are equal or not, if yes condition become true.(a=b) false
!=Check the left operands value are not equal to right operands, if yes return true.a!=b=True
>Check the left operand value is greater than right Operand, if yes condition becomes truea>b=False
<Check the left operand value is less than right Operand, if yes condition becomes truea<b=True
<=Check the left operand value is less than or equal to right Operand, if yes condition becomes truea<=b=True
>=Check the left operand value is greater than or equal to right Operand, if yes condition becomes truea>b=False

## Logical Operator

OperatorDescription
1ANDAnd are use to combined two or more than two condition together. If both the condition is true then return true.
2OROR are use to combined two or more than two condition together, In this case you need at least one condition is true then return result.
3NotNOT operator reverse the meaning of any logical operator

## Truth table of Logical Operator

C1C2C1 AND C2C1 OR C2NOT C1NOT C2
TTTTFF
TFFTFT
FTFTTF
FFFFTT

## Miscellaneous Operator

 Between Not between In Not in Like Exists Not exists Is null Is not null Any All Some Union Union all Intersect minus

Note: All these Miscellaneous Operator later we will discuss in detail.

WIFI CCTV Camera