POWER()
函数说明
POWER(X, Y) 返回 X 的 Y 次方指数值。
函数语法
> POWER(X, Y)
参数释义
参数 | 说明 |
---|---|
X | 必要参数,任何当前支持的数值数据 |
Y | 必要参数,任何当前支持的数值数据 |
示例
drop table if exists t1;
create table t1(a int,b int);
insert into t1 values(5,-2),(10,3),(100,0),(4,3),(6,-3);
mysql> select power(a,b) from t1;
+----------------------+
| power(a, b) |
+----------------------+
| 0.04 |
| 1000 |
| 1 |
| 64 |
| 0.004629629629629629 |
+----------------------+
5 rows in set (0.01 sec)
mysql> select power(a,2) as a1, power(b,2) as b1 from t1 where power(a,2) > power(b,2) order by a1 asc;
+-------+------+
| a1 | b1 |
+-------+------+
| 16 | 9 |
| 25 | 4 |
| 36 | 9 |
| 100 | 9 |
| 10000 | 0 |
+-------+------+
5 rows in set (0.01 sec)