Most math functions from the .Net Math class are supported by N1QL. They may be used anywhere in the query, including where predicates, select projections, and sort ordering.
- Math.Abs
- Math.Acos
- Math.Atan
- Math.Atan2
- Math.Asin
- Math.Ceiling
- Math.Cos
- Math.Exp
- Math.Floor
- Math.Log
- Math.Log10
- Math.Pow
- Math.Round
- Math.Sign
- Math.Sin
- Math.Sqrt
- Math.Tan
- Math.Trunc
- Addition (+)
- Subtraction/Negation (-)
- Multiplication (*)
- Division (/)
- Modulus (%)