SELECT ROUND(COLUMN_NAME, ROUND_OFF_VALUE) FROM TABLE; -- SELECT ROUND(VALUE,X) FROM TABLE; To round off value upto x decimal places