Hello SQL maniacs,
I have a query which is retrieving data from a view.
In this query I use the following line:
replace (sum (column1), ',', '.') as amountpaid,
But it looks like the value I get is rounded by 1 decimal. Cause when I sum the values from the view myself than I get for example 100,86. but when I use the query I get 100,9
Can someone tell me how I get a value with 2 decimals with this query.