Mysql ROUND返回错误值？

Question

我有一个规则表:

rule_id  basic   hra  conveyance  medical
      1    0.5  0.25         800     1250

我运行这个查询:

SELECT ROUND( 16405 ) AS `CTC`, ROUND( 16405 * r.basic ) AS `basic`,
ROUND( 16405 * r.hra ) AS `hra`, r.conveyance AS `conveyance`,
r.medical AS `medical` 
FROM `rule` AS r
WHERE `r`.`rule_id` =1

它返回以下内容:

CTC     basic   hra conveyance  medical  
16405   8202    4101    800          1250

basic 的值应该是 8203 但它返回 8202。

Answer 1

不要使用 ROUND，而是使用 CEIL - 它会四舍五入您的值。

CEIL( 16405 * r.basic ) AS  `basic`