1.4
Arithmetic Operators
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:
End-of-Chapter Survey
: How would you rate the overall quality of this chapter?- Very Low Quality
- Low Quality
- Moderate Quality
- High Quality
- Very High Quality