I am using a Round() function in MySQL query to get a SUM() value with 3 precision. But I am not sure whether this is the best way or get an actual value and round it off in java or js. I am a bit confused about which is the best practice and why? Select ROUND(SUM(ORDER_VALUE),3) from Orders or Answer