Arithmetic Operator

What Are Arithmetic Operators?

SQL supports standard arithmetic operators for performing calculations directly within a query: + (addition), - (subtraction), * (multiplication), and / (division).

Example

SELECT salary, salary * 1.10 AS revised_salary
FROM employees;

Why Testers Use Them

Arithmetic operators let a tester independently recompute expected values — like a total, discount, or tax amount — directly in a query and compare it against what the application displays or stores.