Accuracy in rounding numbers
I have the following requirement-

    1. Get the A_MINUTES column value from TableA for all rows 
    2. Sum the A_MINUTES. 
    3. Convert the summed minutes values to hours - divide by 60 
    4. Round off the final hours value to 2 decimal places.

 

This needs to be written in SQL. 

Do you think this query will have any rounding errors?

    SELECT ROUND ( (SUM(A_MINUTES)/60.0) , 2) FROM TABLEA

 
Accuracy in rounding numbers
===

I have the following requirement-

    1. Get the A_MINUTES column value from TableA for all rows 
    2. Sum the A_MINUTES. 
    3. Convert the summed minutes values to hours - divide by 60 
    4. Round off the final hours value to 2 decimal places.

 

This needs to be written in SQL. 

Do you think this query will have any rounding errors?

    SELECT ROUND ( (SUM(A_MINUTES)/60.0) , 2) FROM TABLEA

 