floor to 2 decimal places sql code example
Example 1: sql limit decimal places
SELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2))
returns: 125.03Example 2: round up and down sql
SQL ROUND UP AND ROUND DOWNSELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2))
returns: 125.03SQL ROUND UP AND ROUND DOWN