SQL Numeric operators

From Recital Documentation Wiki
Revision as of 15:49, 5 July 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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


Products

Recital, Recital Server