MYSQL 中的舍入

debugcn 发表于 Dev

河宝

嗨，试图四舍五入，但似乎无法获得正确的输出。速率信息采用以下格式示例 73.9593 示例 49.7093 需要帮助才能使速率四舍五入，因此 73.9593 应为 74，49.7093 应为 50

SELECT DISTINCT
TEST.Associate,
TEST.Week,
TEST.Function AS FUNCTION,
Sum( TEST.Items ) AS Items,
Sum( TEST.Hours ) AS Hours,
Sum( TEST.Items ) / Sum( TEST.Hours ) AS Rate
FROM
TEST 
    WHERE
TEST.Function = "Pick" 
GROUP BY
TEST.Associate,
TEST.Week,
TEST.Function

HAVING
TEST.Week >= CURRENT_DATE - INTERVAL 2 WEEK

伯努瓦·埃斯纳德

你试过ROUND吗？

SELECT DISTINCT
TEST.Associate,
TEST.Week,
TEST.Function AS FUNCTION,
Sum( TEST.Items ) AS Items,
Sum( TEST.Hours ) AS Hours,
ROUND(Sum( TEST.Items ) / Sum( TEST.Hours )) AS Rate
FROM
TEST 
    WHERE
TEST.Function = "Pick" 
GROUP BY
TEST.Associate,
TEST.Week,
TEST.Function

HAVING
TEST.Week >= CURRENT_DATE - INTERVAL 2 WEEK

您可以通过简单的查询来测试它：

mysql> select round(73.9593);
+----------------+
| round(73.9593) |
+----------------+
|             74 |
+----------------+
1 row in set (0,00 sec)

mysql> select round(49.7093);
+----------------+
| round(49.7093) |
+----------------+
|             50 |
+----------------+
1 row in set (0,00 sec)

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。