- (Negative) (SQL)
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
