Operators In SQL:
Operator symbols are used to perform operation on the basis of operands. In SQL all operators are based into their classification types:
- Arithmatical operators
- Comparison operators
- Logical Operator
- Miscellaneous Operators
| Greater than symbol used to analysis the greater value.
|| a>b(here a is greater than b)
|Less than symbol used to operand the less than value
|| a< b (here a is less than b)
|Greater than equals to compare the value either it is greater than or equals too
||a=>b (here a is either greater than or equals to b)
|Less than equals to compare the value either it is less than or equals too
|| a=<b (here a is either greater than or equals to b)
| Equals to compare both operands on right side and left side.
||a=b (here both operands euals to each other)
|| It check the left value operands are not equal to right operands.
||a!=b (here both operands equals to each other)
|AND Operator combines two or more than two condition together.
If both condition is true then the result became return to true.
|This Operator reverse the meaning of any logical operator.
|OR Operator combines two or more than condition together.
In this condition only one condition is true and other is false.
|It Search the value with in the set of values where it is maximum and minimum
|It searches the specified table for UNIQUENESS
|| Is not null