Arithmetic Operators
- Arithmetic operators can be used in the SELECT, WHERE, and ORDER BY clauses.
- Operators are evaluated in the same way as arithmetic in other contexts.
Table 4. Operators and precedence order
| Operator |
Name |
Order of Precedence |
|
*
|
Multiplication
|
1
|
|
/
|
Division
|
1
|
|
DIV
|
Integer Division
|
1
|
|
% (MOD)
|
Modulo (remainder)
|
1
|
|
+
|
Addition
|
2
|
|
-
|
Subtraction
|
2
|
Code Example:
USE world;
SELECT name, population / SurfaceArea
AS "People per square mile"
FROM country;
Results:
