这样的效果?e.g. ;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 */
加一个0.5 就可以了!
;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
*/