Provide a small code example of use of the ROUND function and explain what this code does
Example: Explain the ROUND () function and its Syntax
SELECT ROUND(125.315, 2);
Result: 125.320 (result is rounded because 3rd parameter is omitted)
SELECT ROUND(125.315, 2, 0);
Result: 125.320 (result is rounded because 3rd parameter is 0)
SELECT ROUND(125.315, 2, 1);
Result: 125.310 (result is truncated because 3rd parameter is non-zero)
SELECT ROUND(125.315, 1);
Result: 125.300 (result is rounded because 3rd parameter is omitted)
SELECT ROUND(125.315, 0);
Result: 125.000 (result is rounded because 3rd parameter is omitted)
SELECT ROUND(125.315, -1);
Result: 130.000 (result is rounded because 3rd parameter is omitted)
SELECT ROUND(125.315, -2);
Result: 100.000 (result is rounded because 3rd parameter is omitted)