How to remove the decimal point from sum in sql

How to remove the decimal point of SUM in SQL: Use the ROUND() function: ROUND(SUM(expression), decimal_places) to retain 0 decimal places: ROUND(SUM(salary), 0) Round to the nearest integer ROUND () function only affects the display of query results and does not affect the data in the table. Permanently delete the decimal point: ALTER TABLE employee ALTER COLUMN salary TYPE INT

## Removed in SQL SUM decimal point

Syntax:

<code>ROUND(SUM(expression), decimal_places)</code>

expression: the expression that requires the sum.
• decimal_places: The number of decimal places to retain. If 0, the result will be rounded to the nearest integer.

Usage example:

<code class="sql">SELECT ROUND(SUM(salary), 0) AS total_salary
FROM employee;</code>

Note:

ROUND() function only affects the display of query results, not the data in the underlying table.
• If you want to permanently remove the decimal point, you can use the ALTER TABLE statement to change the data type of the column. For example:

<code class="sql">ALTER TABLE employee ALTER COLUMN salary TYPE INT;</code>

The above is the detailed content of How to remove the decimal point from sum in sql. For more information, please follow other related articles on the PHP Chinese website!