Arithmetic Operators

Arithmetic opertaors are used to perform arithmetical operations on numeric operands.

Arithmetic Operators

Operator Operation Description
    + Addition It is used to add values of both operand
    - Substraction It is used to subtract right hand side value from the left hand side value
    * Multiplication Multiples the values present on each side of the operator
    % Modulus Divides left hand operand by right hand operand and returns remainder.
    / Divide Divides left hand operand by right hand operand.

Examples :

  • Addition
Query : 
select 20 + 20;
Output :

  • Substraction
Query : 
select 20  - 10;
Output :

  • Multiplication
Query : 
select 10 * 5;
Output :

  • Division
Query : 
select 10 / 2;
Output :
  • Modulus
Query : 
select 12 % 5;
Output :