Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Basic SELECT with expressions and aliases SELECT id, name, price, price * 1.08 AS price_with_tax, UPPER(name) AS name_upper, CASE WHEN price < 50 THEN 'budget' WHEN price < 200 THEN 'mid-range' ELSE 'premium' END AS price_tier, created_at::DATE AS created_date FROM products WHERE is_active = TRUE AND price BETWEEN 10 AND 500 AND name ILIKE '%keyboard%' -- case-insensitive LIKE AND category_id IN (1, 2, 3) ORDER BY price_tier ASC, price DESC NULLS LAST LIMIT 25 OFFSET 0; -- DISTINCT ON — one row per category, the cheapest product SELECT DISTINCT ON (category_id) category_id, name, price FROM products ORDER BY category_id, price ASC; -- POSIX regex — names starting with A or B SELECT name FROM users WHERE name ~ '^[AB]'; -- NULL checks SELECT * FROM users WHERE deleted_at IS NULL; SELECT * FROM users WHERE phone IS NOT NULL;
Result
Open