Limit digits after decimal points in SQL
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).
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).
Code: Select all
SELECT avg(number) FROM table;