SQL - Structured Query Language

Arithmetic Operators



An operator is a symbol specifying an action that is performed on one or more expressions. SQL Server operators can categories into Arithmetic Operators, Assignment Operator, String Concatenation Operator, Comparison Operators, Bitwise Operators, Unary Operators, Compound Operators, Scope Resolution Operator, Logical Operators and SET Operators.

Arithmetic operators are used to execute mathematical operations on two expressions of one or more of the data types of the numeric data type category.

Symbol Name Description
+ Add To Add two or more Numeric and Date value.
- Subtract To Subtract two or more Numeric and Date value.
* Multiply To Multiply two or more Numeric value.
/ Divide To Divide one to another Numeric value.
% Modulo To find out remainder value when divide one to another Numeric value.

* * * * *


Email Your Comment To AUTHOR