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
14. decimal – calculations
Summary

Instruction

Nice work! Did you try to insert a value like 1.236? Did you see what happened? It was rounded to 1.24. This is because we specified two digits after the decimal point when creating the column. Once you provide the precision and scale, you can't exceed it.

Exercise

Let's check how much tax Peter is going to pay on the transactions in the payment table. Select 0.15 of every amount and name this column tax.