how to round off to 1 digitin sql code example Example: sql limit decimal places SELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2)) returns: 125.03