Returns a specified number without any alterations.
Returns distinct rows from the specified source range while omitting duplicates. The order of rows in the result reflects their initial appearance in the source range.
Returns a value treated as a percentage; for example, `UNARY_PERCENT(100)` evaluates to `1`.
Provides a numerical value with the sign inverted.
Calculates a number raised to a specified exponent.
Returns `TRUE` when two specified values differ and `FALSE` when they are the same. This function is equivalent to using the `<>` operator.
Calculates the product of two values. Functions similarly to the `*` operator.
Calculates the subtraction between two numbers, functioning identically to the `-` operator.
Returns `TRUE` if the first argument is less than or equal to the second argument, and `FALSE` otherwise. This is the same as using the `<=` operator.
Returns `TRUE` if the first argument is less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.