Difference between revisions of "SQL Numeric operators"

From Recital Documentation Wiki
Jump to: navigation, search
Line 60: Line 60:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
[[Category:Reference]]
 

Revision as of 15:30, 13 March 2009

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