The functions TRUNC, ROUND, AVG, MIN, and MAX
With ROUND and TRUNC numbers can be rounded off or fractional digits be truncated.
The AVG function calculates the average of the specified values. MIN and MAX calculate the minimum or maximum resp.
If string arguments occur in the functions MIN and MAX, all arguments are interpreted as string values and the result is also returned as a string value. For the functions AVG, MIN, and MAX, NULL value arguments are ignored.
The function SIGN provides the sign of the numeric expression.
Trigonometric functions SIN, COS, ARCTAN
The familiar trigonometric functions. The angle in radians is expected as argument.
Example:
Syntax:
