clickhouse算术函数

最新推荐文章于 2024-05-22 09:20:39 发布

爱上口袋的天空

最新推荐文章于 2024-05-22 09:20:39 发布

阅读量466

点赞数

分类专栏： # ClickHouse数据库

原文链接：https://blog.csdn.net/u010711495/article/details/112387408

版权

ClickHouse数据库专栏收录该内容

30 篇文章 3 订阅

订阅专栏

--求和
SELECT plus(12, 21), plus(10, -10), plus(-10, -10);
+------------+-------------+--------------+
|plus(12, 21)|plus(10, -10)|plus(-10, -10)|
+------------+-------------+--------------+
|33          |0            |-20           |
+------------+-------------+--------------+

--差值
SELECT minus(10, 5), minus(10, -10), minus(-10, -10);
+------------+--------------+---------------+
|minus(10, 5)|minus(10, -10)|minus(-10, -10)|
+------------+--------------+---------------+
|5           |20            |0              |
+------------+--------------+---------------+

--积
SELECT multiply(12, 2), multiply(12, -2), multiply(-12, -2);
+---------------+----------------+-----------------+
|multiply(12, 2)|multiply(12, -2)|multiply(-12, -2)|
+---------------+----------------+-----------------+
|24             |-24             |24               |
+---------------+----------------+-----------------+

--平均值
SELECT divide(12, 4), divide(10, 3), divide(2, 4), divide(-4, -2), divide(-4, 2), divide(-4.5, 3);
+-------------+------------------+------------+--------------+-------------+---------------+
|divide(12, 4)|divide(10, 3)     |divide(2, 4)|divide(-4, -2)|divide(-4, 2)|divide(-4.5, 3)|
+-------------+------------------+------------+--------------+-------------+---------------+
|3            |3.3333333333333335|0.5         |2             |-2           |-1.5           |
+-------------+------------------+------------+--------------+-------------+---------------+

SELECT intDiv(10, 3), divide(10, 3); 
+-------------+------------------+
|intDiv(10, 3)|divide(10, 3)     |
+-------------+------------------+
|3            |3.3333333333333335|
+-------------+------------------+

SELECT divide(10, 0), divide(-10, 0); -- 出现无穷大字符“ ∞ ”或“ -∞ ”
+-------------+--------------+
|divide(10, 0)|divide(-10, 0)|
+-------------+--------------+
|∞            |-∞            |
+-------------+--------------+

SELECT divide(0, 0); -- 特殊字符（类似乱码）
+------------+
|divide(0, 0)|
+------------+
|NaN         |
+------------+

SELECT intDivOrZero(10, 0);
-- 0
+-------------------+
|intDivOrZero(10, 0)|
+-------------------+
|0                  |
+-------------------+

--求余数
SELECT modulo(10, 3); --1
+-------------+
|modulo(10, 3)|
+-------------+
|1            |
+-------------+

SELECT modulo(10.5, 3);
+---------------+
|modulo(10.5, 3)|
+---------------+
|1              |
+---------------+

--取反
SELECT negate(10), negate(-10);
+----------+-----------+
|negate(10)|negate(-10)|
+----------+-----------+
|-10       |10         |
+----------+-----------+

--绝对值
SELECT abs(-10), abs(10);
+--------+-------+
|abs(-10)|abs(10)|
+--------+-------+
|10      |10     |
+--------+-------+

--最大公约数
SELECT gcd(12, 24), gcd(-12, -24), gcd(-12, 24);
+-----------+-------------+------------+
|gcd(12, 24)|gcd(-12, -24)|gcd(-12, 24)|
+-----------+-------------+------------+
|12         |12           |12          |
+-----------+-------------+------------+

--最小公倍数
SELECT lcm(12, 24), lcm(-12, -24), lcm(-3, 4);
+-----------+-------------+----------+
|lcm(12, 24)|lcm(-12, -24)|lcm(-3, 4)|
+-----------+-------------+----------+
|24         |24           |12        |
+-----------+-------------+----------+