2
I am making an SQL query using the function sum()
. This function sums integers and fractional numbers. The problem is that it returns a double Precision with very large number. How do I limit up to two decimal places after the point?
Code
SELECT sum(comprimento * largura * qtde) as met FROM seccionada WHERE cod_secc = 'SE1'
Outcome of the consultation:
40.1699985265732
I wish the answer was:
40.16
Thanks man, the round is the best option. Thanks..
– Francisco Fabio