Literal values

Learn to use constants and calculations inside SELECT.

You can use constant values inside SELECT. It can produce output without even querying a table.

SELECT 'Hello' AS greeting;
SELECT 1 + 1 AS total;

The first query prints Hello on each row. The second returns 2. Text goes in single quotes; numbers do not. You can also compute: price * 2.

The expression 'Merhaba' AS selam is evaluated and returned.

Literal values — details

You can do arithmetic inside SELECT. The +, -, *, / operators work.

SELECT name, price * 1.18 AS with_tax
FROM products;

This multiplies each price by 1.18. A single row can show both a raw column and a computed value.

name, price * 1.18 AS kdvli is selected from products.

Select the price column from products, multiply by 2 and alias it as double_price.

Show example solution

SELECT price * 2 AS cift_fiyat
FROM products

Number calculation

SELECT 2 +____ AS toplam;

Show answer

SELECT 2 + 3 AS toplam;