SQL内置函数学习(数值函数)

数值函数

绝对值

mysql> SELECT ABS(-3);
+---------+
| ABS(-3) |
+---------+
|       3 |
+---------+
1 row in set (0.00 sec)

向上取整

mysql> SELECT CEILING(-1.001);
+-----------------+
| CEILING(-1.001) |
+-----------------+
|              -1 |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT CEILING(1.001);
+----------------+
| CEILING(1.001) |
+----------------+
|              2 |
+----------------+
1 row in set (0.00 sec)

向下取整

mysql> SELECT FLOOR(1.001);
+--------------+
| FLOOR(1.001) |
+--------------+
|            1 |
+--------------+
1 row in set (0.00 sec)

mysql> SELECT FLOOR(-1.001);
+---------------+
| FLOOR(-1.001) |
+---------------+
|            -2 |
+---------------+
1 row in set (0.00 sec)

截取

 select cast(-1.002 as int)

四舍五入

mysql> SELECT ROUND(1.35);
+-------------+
| ROUND(1.35) |
+-------------+
|           1 |
+-------------+
1 row in set (0.00 sec)

e为底的幂

mysql> SELECT EXP(1);
+-------------------+
| EXP(1)            |
+-------------------+
| 2.718281828459045 |
+-------------------+
1 row in set (0.00 sec)

7.取e为底的对数

mysql> SELECT LOG(2.718281828459045);
+------------------------+
| LOG(2.718281828459045) |
+------------------------+
|                      1 |
+------------------------+
1 row in set (0.00 sec)

取10为底对数

mysql> SELECT LOG10(10);
+-----------+
| LOG10(10) |
+-----------+
|         1 |
+