SQL · Reading data

case expression

Returns different values based on conditions. It is an expression, so it can appear in SELECT, WHERE and ORDER BY.

sqlRunnable example sql course

Syntax

case when … then … else … end

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (5), (15), (30))
SELECT minutes,
  CASE WHEN minutes < 10 THEN 'short' WHEN minutes < 25 THEN 'medium' ELSE 'long' END AS length
FROM lessons;

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

case expression

Example

More in this group

Learn this in the course