首页SELECT CAST(SUM(column_name) AS SIGNED) FROM table_name GROUP BY group_column; 不能去除小数点

SELECT CAST(SUM(column_name) AS SIGNED) FROM table_name GROUP BY group_column; 不能去除小数点

时间: 2024-03-27 13:35:12 浏览: 94

SELECT column_name(s)

SELECT column_name(s) FROM table_name WHERE column_name LIKE patternSELECT column_name(s) FROM table_name WHERE column_name LIKE pattern

抱歉，我的回答有误。如果要将MySQL求和结果的小数部分去除，可以使用以下语句： ``` SELECT FLOOR(SUM(column_name)) FROM table_name; ``` 其中，`column_name`为需要求和的列名，`table_name`为表名。`FLOOR`函数将求和结果向下取整，从而去掉小数部分。

阅读全文