Page History
...
BOOL_AND returns true if all expressions are true. BOOL_OR returns true if any expression is true.
Example
Code Block |
---|
SELECT BOOL_AND(ID > 100) FROM Employee |
Example
Code Block |
---|
SELECT BOOL_OR(Name LIKE 'W%') FROM Employee |
STDDEV_POP, STDDEV_SAMP
STDDEV_POP returns the population standard deviation while STDDEV_SAMP returns the sample standard deviation.
Example
Code Block |
---|
SELECT STDDEV_POP(DISTINCT ID) FROM Employee |
Example
Code Block |
---|
SELECT STDDEV_SAMP(ID) FROM Employee |
...
VAR_POP, VAR_SAMP
VAR_POP returns the population variance while VAR_SAMP returns the sample variance.
Example
Code Block |
---|
SELECT VAR_POP(ID) FROM Employee |
Example
Code Block |
---|
SELECT VAR_SAMP(ID) FROM Employee |
...
Numeric Functions (New in 17.0)
...
Returns the absolute value of the numeric expression.
Example
Code Block |
---|
SELECT ABS(Salary) FROM Employee |
...
ACOS
Returns the arc cosine.
Example
Code Block |
---|
SELECT ACOS(D) FROM Employee |
...
ASIN
Returns the arc sine.
Example
Code Block |
---|
SELECT ASIN(D) FROM Employee |
...
ATAN
Calculates the arc tangent.
...