Rounding 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