CASE

CASE is a SQL function in the SELECT Queries category. Conditional expression (like if-else). Can be used in SELECT, WHERE, ORDER BY. The syntax is CASE WHEN condition1 THEN result1 ELSE default END;. It accepts see syntax. It returns computed value based on conditions. A typical example: SELECT name, CASE WHEN salary > 80000 THEN 'High' WHEN salary > 50000 THEN 'Medium' ELSE 'Low' END AS salary_level FROM employees; A close relative is SELECT, which retrieves data from a table. The most fundamental SQL statement. A close relative is SELECT *, which selects all columns from a table. A close relative is SELECT DISTINCT, which returns only distinct (unique) values from the specified columns. More about this category: Core SELECT query clauses — SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT. Related SELECT Queries entries: SELECT, SELECT *, SELECT DISTINCT, WHERE, AND / OR / NOT, IN, BETWEEN, LIKE.