CBRT function - AWS Clean Rooms

CBRT function

The CBRT function is a mathematical function that calculates the cube root of a number.

Syntax

CBRT (number)

Argument

CBRT takes a DOUBLE PRECISION number as an argument.

Return type

CBRT returns a DOUBLE PRECISION number.

Examples

Calculate the cube root of the commission paid for a given transaction:

select cbrt(commission) from sales where salesid=10000; cbrt ------------------ 3.03839539048843 (1 row)