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

Operator	Name	Example (int a=8, b=3)
+	Addition	a+b=11
-	Subtraction	a-b=5
*	Multiplication	a*b=24
/	Division	a/b=2
%	Modulas (Remainder)	a%4=0

Relational Operators

Operators	Description	Example: 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 true	a>b=False
<	Check the left operand value is less than right Operand, if yes condition becomes true	a<b=True
<=	Check the left operand value is less than or equal to right Operand, if yes condition becomes true	a<=b=True
>=	Check the left operand value is greater than or equal to right Operand, if yes condition becomes true	a>b=False

Logical Operator

	Operator	Description
1	AND	And are use to combined two or more than two condition together. If both the condition is true then return true.
2	OR	OR 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.
3	Not	NOT operator reverse the meaning of any logical operator

Truth table of Logical Operator

C1	C2	C1 AND C2	C1 OR C2	NOT C1	NOT C2
T	T	T	T	F	F
T	F	F	T	F	T
F	T	F	T	T	F
F	F	F	F	T	T

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.