Difference between revisions of "SQL Numeric operators"

From Recital Documentation Wiki
Jump to: navigation, search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SQL NUMERIC OPERATORS=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Numeric operators
 
Numeric operators
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[SQL INSERT|INSERT]], [[SQL OPERATORS]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]]
+
[[SQL INSERT|INSERT]], [[SQL OPERATORS|OPERATORS]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]]
  
  
Line 43: Line 36:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
EXEC SQL
+
SELECT name, address, balance, cost*1.15;
SELECT name, address, balance, cost*1.15
+
FROM accounts;
FROM accounts
+
WHERE paid_date < date() AND ord_value > 10000;
WHERE paid_date < date() AND ord_value > 10000
+
ORDER BY name, paid_date
ORDER BY name, paid_date;
+
  
EXEC SQL
+
SELECT account_no, ord_value – paid_value as "Outstanding Balance";
SELECT account_no, ord_value – paid_value as "Outstanding Balance"
+
FROM accounts;
FROM accounts
+
ORDER BY account_no
ORDER BY account_no;
+
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
[[Category:SQL]]
+
[[Category:SQL|Operators,Numeric]]
[[Category:Reference]]
+

Latest revision as of 15:49, 5 July 2011

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