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
12. decimal – inserting data
Summary

Instruction

Great! How do we write decimal numbers in SQL? The answer is simple: just as you write floating point numbers. The number 1.5 still stands for one and a half. Quite convenient, isn't it?

Exercise

We've got a new payment from the user with user_id = 13. He made a payment in the amount of $314.27. Insert this data into the payment table.