SQL

round in sql server

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)
SELECT ROUND(2.5,0) 
-- Result 3
SELECT ROUND(2.4,0) 
-- Result 4

round .5 to 1 in sql server

SELECT ROUND(2.5,0) -- Result: 3
SELECT ROUND(2.4,0) -- Result: 2