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
-- Searched CASE (most common):
CASE
WHEN marks >= 90 THEN 'A+'
WHEN marks >= 80 THEN 'A'
ELSE 'C'
END AS grade
-- Conditional aggregation (pivot):
SUM(CASE WHEN marks >= 90 THEN 1 ELSE 0 END) AS a_plus_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 →