15.abs 取绝对值
select abs(-100)from dual;
16.acos 反余弦
select acos(-1) frm dual;
17.asin 反正弦
Select asin(0.5) from dual;
18.atan 反正切
Select atan(1) from dual;
19.cosh 反余弦
Select cosh(20) from dual;
20.ceil 向上取整
Select ceil(3.14) from dual;
21.floor 向下取整
Select floor(20.5) from dual;
22.round(a1) 四舍五入 trunc 截取
Select round(42.3) from dual;
Select trunc(623.566),trunc(623.566,2),trunc(623.566,-2)from dual;
23.exp e的n次方根
Select exp(2),exp(1) from dual;
24.ln(a1) 返回以e为底a1的对数
Select ln(2.715) from dual;
25.log(a1,a2) 以a1为底a2的对数
Select log(2,4) from dual;
26.mod(a1,a2) 取模,取余
Select mod(5,2) from dual;
27.power(a1,a2) a1的a2次方
Select power(2,4) from dual;
补充
50.avg(distinct|all) 平均值 distinct:除去重复值,all:所有,包括数据为null的值,当做0
51.max(distinct|all) 最大值
52.min(distinct|all) 最小
53.stddev(distinct|all) 标准差
Select stddev(sal) from emp;
54.variance(distinct|all) 方差
Select variance(sal) from emp;
oracle函数-算数函数
最新推荐文章于 2023-04-22 20:37:52 发布