Decimal types

Learn DECIMAL, NUMERIC, FLOAT decimal types.

For decimal numbers you use DECIMAL, NUMERIC and FLOAT. DECIMAL is preferred for money; FLOAT gives approximate values.

CREATE TABLE products (
  price DECIMAL(10, 2),
  rate FLOAT
);

Price has 10 digits, 2 decimals; rate is an approximate decimal.

The table products is created.

Decimal types — details

DECIMAL(10, 2) means 10 total digits, 2 after the decimal point. FLOAT is used in scientific computing but not for money because of rounding errors.

Add a price DECIMAL(10,2) column to products.

Show example solution

CREATE TABLE products (
  price DECIMAL(10, 2)
)

Decimal type

CREATE TABLE t (price ____(10, 2));

Show answer

CREATE TABLE t (price DECIMAL(10, 2));