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
POW FunctionThe POW function raises its first numeric argument, the base, to the power of its second numeric argument, the exponent. The returned value is a FLOAT data type.

POW Function

The POW function raises its first numeric argument, the base, to the power of its second numeric argument, the exponent. The returned value is a FLOAT data type.

The following example returns all rows from the circles table in which the radius column value implies an area less than 1,000 square units, using an approximation to pi with a scale of 4:

SELECT * FROM circles WHERE (3.1416 * POW(radius,2)) < 1000;

The function identifier Power® is a synonym for POW.

To use e, the base of natural logarithms, see EXP Function.