O'Reilly logo

SQL: Visual QuickStart Guide by Chris Fehily

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Approximate Numeric Types

Use approximate numeric data types to represent approximate numerical values. An approximate numerical value has these characteristics:

  • It can be a negative, zero, or positive number.

  • It’s considered to be an approximation of a floating-point (real) number.

  • It typically is used to represent very small quantities, very large quantities, or scientific calculations.

  • It’s expressed in scientific notation. A number in scientific notation is written as a decimal number multiplied by an (integer) power of 10. An uppercase E is the exponentiation symbol: 2.5E2 = 2.5 × 102 = 250, for example. The mantissa is the portion that expresses the significant digits (2.5 here) and the exponent is the power of 10 (2 here). The mantissa and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required