trunc vs round sql code example Example: round in sql SELECT ROUND (commission_pct, 0) From employees;