取整问题

[ColdFusion_JK]

比如
select 3/2
我怎么能得到
2?
就是只要除 有余数 就进1...

[areswang]

SELECT CEILING(3.0/2)

[qiyousyc]

select ceiling(@num1*1.0/@num2)

[OracleRoob]

--需要对整数先转换，如：乘以1.0，或直接cast(3 as decimal(10,2))

select ceiling(3*1.0/2)

[nj_1st_excellence]

select ceiling(3/2.0)

[-狙击手-]

select ceiling(3*1.0/2)

[utpcb]

select floor(convert(float,被除数)/除数+0.99999) 你如果要精度的话就在后面灾添9

[wzy_love_sly]

select ceiling(3*1.0/2)

2
--例子

SELECT CEILING($123.45), CEILING($-123.45), CEILING($0.0)

124.00 -123.00 0.00

[dobear_0922]

declare @num1 int,@num2 int
set @num1=3
set @num2=2

select (@num1+@num2-1)/@num2

/*
-----------
2

(1 row(s) affected)
*/

[dobear_0922]

declare @num1 int,@num2 int
set @num1=3
set @num2=2

select (@num1+@num2-1)/@num2

/*
-----------
2

(1 row(s) affected)
*/

[fcuandy]

SELECT  CASE WHEN 3%2!=0 THEN 1+3/2 ELSE 3/2 END

SELECT ISNULL(LEFT(NULLIF(3%2,0),0)+RTRIM(3/2+1),3/2)

SELECT CEILING(3*1.0/2)

[dobear_0922]

还是11楼的最简洁，呵呵，，，

select (3+2-1)/2

[fcuandy]

hehe

[zefuzhang2008]

呵呵，我同意以上答案

[zdlou]

select ceiling(3*1.0/2)

[cxmcxm]

SELECT CEILING(3*1.0/2)

[dawugui]

select result = ceiling(3*1.0/2)

/*
result      
----------- 
2
（所影响的行数为 1 行）
*/

[zefuzhang2008]

select ceiling(3*1.0/2)

[leisure_cool]

declare @a int,@b int
set @a=3
set @b=2
select ceiling(cast(@a as float)/@b)

[lhsxsh]

select ceiling(3*1.0/2)

[lhsxsh]

select Cast((11) AS numeric)/2