Open navigation menu

Basic SELECT with Column Aliases

Demonstrates a basic SELECT query with column aliases, literal expressions, and calculated columns for retrieving and shaping data from a table.

SqlData Fetching

Code

snippet
SELECT
    product_id AS id,
    product_name AS "Product Name",
    unit_price AS price,
    unit_price * 1.1 AS price_with_tax,
    'USD' AS currency,
    CURRENT_DATE AS query_date
FROM products
WHERE category_id = 1
  AND unit_price > 10.00
ORDER BY unit_price DESC
LIMIT 10;

Related Examples