- (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