SQL Numeric operators

Purpose

Numeric operators

Syntax

<expression1> operator <expression2>[ operator <expression3>…]

See Also

INSERT, OPERATORS, SELECT, UPDATE

Description

Operators used with Numeric expressions:

Operator	Operation
**	Exponentiation
*	Multiplication
/	Division
%	Modulus/Remainder
+	Addition
-	Subtraction

Example

SELECT name, address, balance, cost*1.15;
FROM accounts;
WHERE paid_date < date() AND ord_value > 10000;
ORDER BY name, paid_date
 
SELECT account_no, ord_value – paid_value as "Outstanding Balance";
FROM accounts;
ORDER BY account_no