In SQL We have 2 Basic Types of Numbers that retain Detailed Numbers

Fixed Point

Floating Point

DECIMAL (Max,afterDecimal)

DECIMAL (10,4)

123456.7890

FLOAT

DOUBLE

Holds a number up to 4 Bytes in Size

Holds a number up to 8 Bytes in Size

0000 0000 0000 0000 0000 0000 0000 0000

0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000

Once again, control over the amount of memory used to process the variables plays a role, less space is the best

Numbers With Fractional Components