Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
Algebraic Functions
ROOT FunctionThe ROOT function extracts a positive real root value, returned as a FLOAT data type, from its first numeric expression argument, the radicand.

ROOT Function

The ROOT function extracts a positive real root value, returned as a FLOAT data type, from its first numeric expression argument, the radicand.

If you specify a second numeric argument as the index, which cannot be zero, then the returned value to the power index is equal (within rounding error) to the radicand argument. If only the radicand argument is supplied, 2 is the default index value. You cannot specify zero as the value of index.

The first SELECT statement in the following example, which uses the default index value of 2, returns the positive square root of the literal number 9. The second example returns the cube root of the literal number 64.

SELECT ROOT(9) FROM angles;         -- square root of 9
SELECT ROOT(64,3) FROM angles;      -- cube root of 64

Invoking ROOT with only a single argument is equivalent to invoking the SQRT function.