Arithmetic operators

Learn +, -, *, /, % arithmetic operators.

SQL uses +, -, *, /, % arithmetic operators in SELECT to compute values.

SELECT price * 1.18 AS kdvli FROM products;

This query multiplies price by 1.18; adds tax.

price * 1.18 AS kdvli is selected from products.

Arithmetic operators — details

Modulus % gives the remainder of division. For integer division use FLOOR or CAST depending on the database.

Select price times 1.18 aliased as with_tax from products.

Show example solution

SELECT price * 1.18 AS kdvli
FROM products

Multiplication

SELECT price ____ 2 FROM products;

Show answer

SELECT price * 2 FROM products;