I can’t find in the documentation how i’m supposed to do something like this :
SELECT ROUND(MEAN(value), 2) ...
to get a value like 1.79
instead of 1.7925925925925925.
I can’t find in the documentation how i’m supposed to do something like this :
SELECT ROUND(MEAN(value), 2) ...
to get a value like 1.79
instead of 1.7925925925925925.
Try round(mean(value)*100)/100 …
Regards,
Antony.
Thanks for the tips Antony !
Too bad the ROUND function isn’t like the SQL one, it would be a lot more readable