Skip to main content

MINUS

Negates a numeric value.

Syntax

MINUS( <x> )

Aliases

Examples

SELECT MINUS(PI()), NEG(PI()), NEGATE(PI()), SUBTRACT(PI());

┌───────────────────────────────────────────────────────────────────────────────────┐
│ minus(pi()) │ neg(pi()) │ negate(pi()) │ subtract(pi())
├────────────────────┼────────────────────┼────────────────────┼────────────────────┤
-3.141592653589793-3.141592653589793-3.141592653589793-3.141592653589793
└───────────────────────────────────────────────────────────────────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today