Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Data Types in SQL

Numerical data types
Integer data types
Floating point data types
8. Floating point numbers – notation
Decimal data types
Summary

Instruction

All right! You might wonder how double precision and real numbers are stored in the database.

It's pretty straightforward; you write the numbers just as you do in English: 1.5 stands for one and a half.

If you want to store really big or really small numbers in your database, you can use scientific notation in double precision and real columns. For instance, 1.26e4 stands for 1.26 * 10^4, which is 12,600.

Good to know: The letter "e" is the only letter allowed in number fields because it specifies the exponent for the base 10.

Exercise

Our first daredevil is ready to specify his weight. The user with ID of 10 weighs 87.3 kg (about 192 pounds). Put this information into the body table.