Round sum of decimal column in sql

sql sql-server

The ROUND() function is used to round a numeric field to the number of decimals specified.

Syntax:

SELECT ROUND(column_name,decimals) FROM table_name;

For your problem, try this:

CONVERT(int,ROUND(SUM(Amount),0)) as TotalAmount --Converting to int to remove the fractional part

Read more about ROUND here.

sql sql-server

If you want to round and remove the fractional part you can simply CAST it to a DECIMAL with different precision:

select cast(SUM(Amount) as DECIMAL(18,0)) as TotalAmount

sql sql-server

ROUND(SUM(Amount),0) as TotalAmount

CodeHunter