34,590
社区成员
发帖
与我相关
我的任务
分享
;WITH CTET(Num)
AS
(
SELECT CAST(1.249999 AS float)
UNION ALL
SELECT 1.3
UNION ALL
SELECT 1.69
UNION ALL
SELECT 1.7
UNION ALL
SELECT 1.75
UNION ALL
SELECT 1.9
)
SELECT *,CEILING(FLOOR(Num*4)/2)/2 AS Num2 FROM CTET
/*
Num Num2
1.249999 1
1.3 1.5
1.69 1.5
1.7 1.5
1.75 2
1.9 2
*/