34,587
社区成员
发帖
与我相关
我的任务
分享
DECLARE @T TABLE(Col1 DECIMAL(18,2))
INSERT INTO @T SELECT 1.78
INSERT INTO @T SELECT 2.35
INSERT INTO @T SELECT 2.56
SELECT CAST(Col1/0.5 AS INT)*0.5 FROM @T
/*
1.5
2.0
2.5
*/
select (case when A-cast(A as int)>0.5 then cast(cast(A as int) as decimal)+0.5
else cast(cast(A as int) as decimal) end ) as col1
from t1