Operators in SQL


Prev Tutorial Next Tutorial

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)
+Additiona+b=11
-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

BetweenNot betweenIn
Not inLikeExists
Not existsIs nullIs not null
AnyAllSome
UnionUnion allIntersect
minus

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


Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements