Solution: Use NUMERIC Data Type
Let's solve the antipattern by using the NUMERIC data type.
We'll cover the following...
Instead of FLOAT or its siblings, let’s use the NUMERIC or DECIMAL SQL data types for fixed-precision fractional numbers.
Press + to interact
ALTER TABLE Bugs ADD COLUMN hours NUMERIC(9,2);ALTER TABLE Accounts ADD COLUMN hourly_rate NUMERIC(9,2);
Precision and scale
The NUMERIC and DECIMAL data types store numeric values exactly, up to the precision we specify in ...