docs.intersystems.com
Home  /  Application Development: Core Topics  /  InterSystems SQL Reference  /  SQL Unary Operators  /  - (Negative)


InterSystems SQL Reference
- (Negative)
[Next] 
InterSystems: The power behind what matters   
Search:  


A unary operator that returns an expression as a negative, numeric value.
Synopsis
-expression
Arguments
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 an InterSystems 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
+ (Positive)