- (Negative)
A unary operator that
returns an expression as a negative, numeric value.
Synopsis
-expression
Arguments
Argument | Description |
---|---|
expression | A numeric expression. |
Description
Unary operators perform an operation on only one expression of any of the data types of the numeric data type category.
– (Negative) is a Caché SQL extension.
Examples
The following example returns three numeric fields: the Age column from Sample.Person; the – (Negative) value of the average of Age; and the Age minus the average age:
SELECT Age,
-(AVG(age)) AS NegAvg,
Age-AVG(Age) AS AgeRelAvg
FROM Sample.Person
See Also
Purpose of this instance: Draft documentation
DocReleaseID: Core2018.1.11
Content loaded from:
/staging/ce/2018.1.11/doc/cache/en-us/src/
/staging/ce/2018.1.11/doc/ensemble/en-us/src/
/staging/ce/2018.1.11/doc/isp/en-us/src/
/staging/learning/zenmojo-doc/en-us/src/