SQL
Apply Conditional Logic in SQL Queries with CASE
Use SQL's powerful CASE statement to implement conditional logic directly within your queries, categorize data, or perform different calculations based on specific criteria.
SELECT
order_id,
total_amount,
CASE
WHEN total_amount > 500 THEN 'High Value'
WHEN total_amount > 100 THEN 'Medium Value'
ELSE 'Low Value'
END AS order_category
FROM orders;
How it works: The CASE statement allows you to define different outcomes based on various conditions, similar to 'if-else' logic in programming languages. It can be used in SELECT, WHERE, ORDER BY, and GROUP BY clauses. This example categorizes orders into 'High Value', 'Medium Value', or 'Low Value' based on their total amount, making it easier to analyze and report on your data.