Webmaster2020.com

Posted: **Wed Sep 27, 2017 9:22 pm**

Hello,

I have a database with a lot of numbers,
I try to get the average, that works but I get up to 8 digits behind the decimal point (mostly 0).

SELECT avg(number) FROM table;

Posted: **Thu Sep 28, 2017 6:40 pm**

I know 2 ways:
With round

SELECT ROUND( AVG(number) , 2 ) FROM table;

Or with DECIMAL:

SELECT ( AVG(number) AS DECIMAL(16, 2) )FROM table;

Both should work

Limit digits after decimal points in SQL