💡 Built by developers, for developers. This site is now part of Beekeeper Studio - the open source SQL editor.
SQL CASE Tutorial - Interactive Database Lesson
Lesson 29 of 31
CASE
Interactive SQL TutorialYou can use a CASE statement to return certain values when certain scenarios are true.
A CASE statement takes the following form:
CASE WHEN *first thing is true* THEN *value1*
WHEN *second thing is true* THEN *value2*
...
ELSE *value for all other situations*
END
For example, in order to return the number of legs for each row in friends_of_pickles, you could run:
SELECT *,
CASE WHEN species = 'human' THEN 2 ELSE 4 END AS num_legs
FROM friends_of_pickles;
Can you return the results with a column named sound that returns “talk” for humans, “bark” for dogs, and “meow” for cats?
SQL: