Round a number in sql

learn how to Round a number in sql

For  that you can make use of Round Function


round(expression, length)


examples:



ROUND(123.9994, 3)     ==> 123.9990  



ROUND(123.9995, 3     ==> 124.0000  



ROUND(123.9994, 0)     ==>  124



ROUND(123.45, -2)     ==>  100