日期:2014-05-18 浏览次数:20459 次
select case when quantity%2=0 then quantity/2 else quantity/2+1 end as quantity from tb ------解决方案--------------------
select ceiling(quantity/2.0) from E_CHECKD