SQL Numeric operators

SQL NUMERIC OPERATORS

Class

SQL Applications

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

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

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer