我需要從表中檢索一個欄位，如果還不是整數，則顯示四舍五入到下一個整數的結果。
例如：
我的桌子上有現場作業時間。
我需要創建以下邏輯。
If working hours/15 equals to 4.01 or whatever grater 4.0 then round to 5
否則選擇原樣 (4.0)。
uj5u.com熱心網友回復：
這是你想要的嗎？
with t (n) as (
select 17.813 from dual
union all select 20.126 from dual
union all select 1.000 from dual
union all select 1.001 from dual
union all select 1.005 from dual
union all select 1.009 from dual
union all select 1.010 from dual
union all select -1.000 from dual
union all select 0 from dual
union all select -1.001 from dual
union all select -1.005 from dual
union all select -1.009 from dual
union all select -1.010 from dual
)
select n, ceil(n) as next_num
from t;
N NEXT_NUM
17.813 18
20.126 21
1 1
1.001 2
1.005 2
1.009 2
1.01 2
-1 -1
0 0
-1.001 -1
-1.005 -1
-1.009 -1
-1.01 -1
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/349022.html