`round({n}[,{m}])`

Returns the value of n rounded to m decimal places. m can be negative, in which case the function returns n rounded to -m places to the left of the decimal point. If m is omitted, it returns n rounded to the nearest integer. For tie-breaking, it follows round half way from zero convention. n can be any real numeric value in the range of -1.797e308 <= n <= 1.797e308. m can be an integer value between -15 and 15, inclusive.

round({n}[,{m}]) takes the following syntax.

1SELECT round(N[,M]) as AliasName
2FROM dataset;

Example

This example returns 47.385 rounded to the first decimal place.

1SELECT round(47.385, 1) as roundExample FROM Superstore
2LIMIT 1;

roundExample
47.4