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
Decimal data types
13. decimal – values out of range
Summary

Instruction

Good job! You deserve another break. Let's play around with some decimal numbers.

Exercise

Experiment with the values in the column amount and try some which are out of range. We specified two digits after the decimal point, so try to insert a value that has three.

Here is a quick reminder of the table definition:

CREATE TABLE payment (
  user_id integer,
  amount decimal(6, 2)
);