SQL函數(shù)：求select sign(
2 回答
守著一只汪
TA貢獻(xiàn)1872條經(jīng)驗(yàn) 獲得超4個(gè)贊
Oracle/PLSQL: Sign Function
在 Oracle/PLSQL, sign 函數(shù)返回一個(gè)值來(lái)說(shuō)明數(shù)字的符號(hào)，語(yǔ)法如下
sign( number )
If number < 0, then sign returns -1.
If number = 0, then sign returns 0.
If number > 0, then sign returns 1.
For example:
sign(-23) would return -1
sign(-0.001) would return -1
sign(0) would return 0
sign(0.001) would return 1
sign(23) would return 1
sign(23.601) would return 1
紫衣仙女
TA貢獻(xiàn)1839條經(jīng)驗(yàn) 獲得超15個(gè)贊
sign 取得是數(shù)據(jù)的 符號(hào)，當(dāng)數(shù)據(jù)為0的時(shí)候 返回結(jié)果為0。
如：select sign(1-2) from dual; 結(jié)果 -1
select sign (-2) from dual; 結(jié)果 -1
select sign(-0) from dual; 結(jié)果 0
- 2 回答
- 0 關(guān)注
- 1270 瀏覽
添加回答
舉報(bào)
0/150
提交
取消