Skip to content

Glossary: SQL Basics

Rounding error

Also written: decimal rounding error, binary decimals

Computers store most decimals in binary, so they can't be held exactly, and a calculation can show results like `5.76000000000001`. Wrapping the whole calculation in ROUND fixes the display.

Where the book teaches it

Related terms

ROUNDprintf