Data Archive
- Data Archive 6.4.3
- All Products
POWER (double value-expression1, double value-expression2) POW (double value-expression1, double value-expression2)
|
|
---|---|
|
|
|
|
|
|
|
|
CREATE TABLE num_table (col1 SMALLINT, col2 SMALLINT); INSERT INTO num_table VALUES (4, 8); 1 row affected SELECT POWER(col1, col2) FROM num_table; 1 row selected 1 ----------- 65536 SELECT POWER(4.0, col2) FROM num_table; 1 row selected 1 ---------------------- 6.55360000000000e+04 SELECT POWER(col1, 0.5) FROM num_table; 1 row selected 1 ---------------------- 2.00000000000000e+00 SELECT POWER(col1, -2.0) FROM num_table; 1 row selected 1 ---------------------- 6.25000000000000e-02