SQL CASE

SQL 25 May 2025

Usage

SELECT name,
	CASE WHEN age >= 18 THEN 'Adult' ELSE 'Minor' END AS status
FROM people

Sources

W3Schools: CASE