CASE adds if-then-else logic to your SQL queries. Create conditional columns and complex categorizations.

Basic CASE Syntax

SELECT

CASE

WHEN condition1 THEN result1

WHEN condition2 THEN result2

ELSE default_result

END as column_name

FROM table;

Simple CASE

SELECT name,

CASE status

WHEN 'A' THEN 'Active'

WHEN 'I' THEN 'Inactive'

ELSE 'Unknown'

END as status_text

FROM customers;

CASE with Ranges

SELECT product_name, price,

CASE

WHEN price < 10 THEN 'Budget'

WHEN price < 50 THEN 'Mid-range'

WHEN price < 100 THEN 'Premium'

ELSE 'Luxury'

END as price_tier

FROM products;

CASE in ORDER BY

SELECT * FROM orders

ORDER BY

CASE status

WHEN 'urgent' THEN 1

WHEN 'normal' THEN 2

ELSE 3

END;

CASE in Aggregations

SELECT

COUNT(CASE WHEN status = 'active' THEN 1 END) as active_count,

COUNT(CASE WHEN status = 'inactive' THEN 1 END) as inactive_count

FROM customers;

Generate CASE Queries

Describe your conditions and AI2sql builds the CASE statement.