Oracle和MS SQL server的函数对比.zt
上一篇 / 下一篇 2007-12-19 18:34:00 / 个人分类:数据库
---------数学函数
1.绝对值51Testing软件测试网&xS%q%u:o}]
FO
S:select abs(-1) value
Z^`:Jm#i9jsTi0 O:select abs(-1) value from dual
S:select abs(-1) value
Z^`:Jm#i9jsTi0 O:select abs(-1) value from dual
2.取整(大)
]A-J/kJ4d0 S:select ceiling(-1.001) value
V} T2t k4T7m(\~0 O:select ceil(-1.001) value from dual
]A-J/kJ4d0 S:select ceiling(-1.001) value
V} T2t k4T7m(\~0 O:select ceil(-1.001) value from dual
3.取整(小)
2jJ9XP^8Rt0 S:select floor(-1.001) value51Testing软件测试网3hP uy%w1T0\`
O:select floor(-1.001) value from dual
2jJ9XP^8Rt0 S:select floor(-1.001) value51Testing软件测试网3hP uy%w1T0\`
O:select floor(-1.001) value from dual
4.取整(截取)
/zqs*|4wy;X0 S:select cast(-1.002 as int) value51Testing软件测试网9~&Uj:f4VJ~gUU
O:select trunc(-1.002) value from dual
/zqs*|4wy;X0 S:select cast(-1.002 as int) value51Testing软件测试网9~&Uj:f4VJ~gUU
O:select trunc(-1.002) value from dual
5.四舍五入
!i? ZhXqM woY0 S:select round(1.23456,4) value 1.23460
N_;z:L1cw0 O:select round(1.23456,4) value from dual 1.2346
!i? ZhXqM woY0 S:select round(1.23456,4) value 1.23460
N_;z:L1cw0 O:select round(1.23456,4) value from dual 1.2346
6.e为底的幂
)~5spBp7H^_0 S:select Exp(1) value 2.7182818284590451
$fZt1Dw*C0 O:select Exp(1) value from dual 2.71828182
)~5spBp7H^_0 S:select Exp(1) value 2.7182818284590451
$fZt1Dw*C0 O:select Exp(1) value from dual 2.71828182
7.取e为底的对数51Testing软件测试网G3A0z7bDz(Xo
S:select log(2.7182818284590451) value 1
dom["S^5cO0 O:select ln(2.7182818284590451) value from dual; 1
S:select log(2.7182818284590451) value 1
dom["S^5cO0 O:select ln(2.7182818284590451) value from dual; 1
8.取10为底对数
l{J a{0 S:select log10(10) value 1
AA/H H['[C0 O:select log(10,10) value from dual; 1
l{J a{0 S:select log10(10) value 1
AA/H H['[C0 O:select log(10,10) value from dual; 1
9.取平方51Testing软件测试网9Xa[g%MB$E&n{
S:select SQUARE(4) value 1651Testing软件测试网(@&M*XAgo
O:select power(4,2) value from dual 16
S:select SQUARE(4) value 1651Testing软件测试网(@&M*XAgo
O:select power(4,2) value from dual 16
10.取平方根
1Zc N.Yg0 S:select SQRT(4) value 251Testing软件测试网,Mj#rX,Px
O:select SQRT(4) value from dual 2
1Zc N.Yg0 S:select SQRT(4) value 251Testing软件测试网,Mj#rX,Px
O:select SQRT(4) value from dual 2
11.求任意数为底的幂51Testing软件测试网g4U"Y.eS,{k^P4y)}
S:select power(3,4) value 8151Testing软件测试网j)q,bm0H6ua
O:select power(3,4) value from dual 81
S:select power(3,4) value 8151Testing软件测试网j)q,bm0H6ua
O:select power(3,4) value from dual 81
12.取随机数51Testing软件测试网9p0] lI\
S:select rand() value51Testing软件测试网7h[` M u c$i%RA}
O:select sys.dbms_random.value(0,1) value from dual;
S:select rand() value51Testing软件测试网7h[` M u c$i%RA}
O:select sys.dbms_random.value(0,1) value from dual;
13.取符号
#og6b"p(QW,Nn5}0 S:select sign(-8) value -1
Sh*oCFl.f|0 O:select sign(-8) value from dual -151Testing软件测试网4ybMjq,Z3}8g?
----------数学函数
#og6b"p(QW,Nn5}0 S:select sign(-8) value -1
Sh*oCFl.f|0 O:select sign(-8) value from dual -151Testing软件测试网4ybMjq,Z3}8g?
----------数学函数
14.圆周率
/lW6u*v MmE0 S:SELECT PI() value 3.1415926535897931
Tf1@0[8k-|&s0 O:不知道
/lW6u*v MmE0 S:SELECT PI() value 3.1415926535897931
Tf1@0[8k-|&s0 O:不知道
15.sin,cos,tan 参数都以弧度为单位
}$cr+D+~`0 例如:select sin(PI()/2) value 得到1(SQLServer)
}$cr+D+~`0 例如:select sin(PI()/2) value 得到1(SQLServer)
16.Asin,Acos,Atan,Atan2 返回弧度
17.弧度角度互换(SQLServer,Oracle不知道)
xZ#Z3Wp RUa&w0 DEGREES:弧度-〉角度
Y]#E_&LA0 RADIANS:角度-〉弧度
xZ#Z3Wp RUa&w0 DEGREES:弧度-〉角度
Y]#E_&LA0 RADIANS:角度-〉弧度
---------数值间比较
18. 求集合最大值
0S.yAP q.\!dQ0 S:select max(value) value from51Testing软件测试网AzV H:h3[ WJ|"P
(select 1 value51Testing软件测试网 b`'f`XB0r.] w9|'U
union
1A `MB{yBY0 select -2 value
4o^I\T:z#V0 union51Testing软件测试网M+DCfp S5@)n%F
select 4 value
C+}/KKuJ*^:js0 union
0S.yAP q.\!dQ0 S:select max(value) value from51Testing软件测试网AzV H:h3[ WJ|"P
(select 1 value51Testing软件测试网 b`'f`XB0r.] w9|'U
union
1A `MB{yBY0 select -2 value
4o^I\T:z#V0 union51Testing软件测试网M+DCfp S5@)n%F
select 4 value
C+}/KKuJ*^:js0 union