SQL Arithmetic Operators

There are 3 types of Operators in SQL.

1.Arithmetic operators
2.Comparison operators
3.Logical operators

Arithmetic operators have highest precedence than other operators.

  • + Add
  • – Subtract
  • * Multiplication
  • / Division
  • % Remainder

 
Add +

We can perform addition using +


 
Subtract –

if you want to subtract some value you will use – with the column value.


 
Multiplication *

we do multiply with *


 
Divide /
We perform divide using /

 
Reminder %
When we want to have Reminder we will use %