Sql Case When — Free Sql Tutorial
Learn Sql Case When in Sql with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.
TL;DR: Learn Sql Case When in Sql with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.
Written & reviewed by the Syllab.in Academic Team (CBSE/NCERT subject experts) · Updated
Sql Case When in Sql
CASE WHEN is SQL's if-then-else. It allows conditional logic directly inside SELECT queries to categorise data, create computed columns, and transform values.
Searched CASE evaluates multiple independent conditions. Simple CASE compares one expression to multiple values (like a switch statement). Both return the first matching WHEN value.
Conditional aggregation with CASE: SUM(CASE WHEN condition THEN 1 ELSE 0 END) counts rows matching a condition — enables pivot-style reports in standard SQL.
Sql Case When — Syntax
CASE WHEN condition THEN value WHEN condition THEN value ELSE default_value END AS alias -- Conditional count SUM(CASE WHEN status='active' THEN 1 ELSE 0 END) AS active_count
Learn Sql Case When step by step with Syllab's free interactive Sql tutorial — runnable code examples, practice exercises and instant AI feedback, all free with no signup. Explore the full Sql course →