Ravindra BagaleCourses & study guides Track your progress

CASE WHEN: If-Then Logic in SQL — Ravi Sir's Cards

All SQL cards

Revision cards

CASE WHEN is SQL's IF. Reports need simple labels like Small or Large, not only raw amounts.
CASE WHEN is SQL's IF · PNG

Interview cards

What is CASE WHEN? CASE WHEN is SQL's IF. It picks a result based on conditions and finishes with the word END.
What is CASE WHEN? · PNG

Comparison cards

CASE vs WHERE. WHERE decides which rows appear in the result. CASE adds a label or a new value to the rows you keep.
CASE vs WHERE · PNG