Purpose: Used to perform mathematical calculations on numeric values.Operators:
+
: Addition-
: Subtraction*
: Multiplication/
: Division%
: Modulus (remainder)
Example:
SELECT salary, salary * 0.1 AS bonus FROM employees;
Explanation: This calculates a 10% bonus on the salary
for each employee.
Leave a Reply