# SQL Arithmetic Operators (Addition, Subtraction, Multiplication, Division)

In SQL, arithmetic operators are useful to perform mathematical operations like addition ( ), subtraction (-), multiplication (*), division (/), module (%) on SQL statements. In SQL, we have a different type of arithmetic operators available, those are

• SQL Subtraction (-) Operator
• SQL Multiplication (*) Operator
• SQL Division (/) Operator
• SQL Modulus (-) Operator

In SQL, addition operator are used to perform an addition of numbers .

Example:

Following is the example of using addition operator in sql server.

Select 17+5

If we execute the above SQL query, we will get the result as 22.

## SQL Subtraction (-) Operator

In SQL, the subtraction operator is useful to perform a subtraction of numbers.

Example:

Following is the example of using subtraction operator in sql server.

Select 17-5

If we execute above SQL query, we will get the result as 12.

## SQL Multiplication (*) Operator

In SQL, the multiple operator is useful to perform multiplication of numbers.

Example

Following is the example of using a multiplication operator in sql server.

Select 17*5

If we execute above SQL query, we will get the result as 85.

## SQL Division (/) Operator

In SQL, division operator is used to perform a division of numbers.

Example:

Following is the example of using a division operator in sql server.

Select 17/5

If we execute the above SQL query, we will get the result as 3.

## SQL Modulus (%) Operator

In SQL, the modulus operator is useful to perform a division of numbers and returns a remainder of division operation.

Example:

Following is the example of using a modulus operator in sql server.

Select 17%3

If we execute above SQL query, we will get the result as 2.