SQL CASE Statement
The CASE statement in SQL is a versatile conditional expression that enables us to incorporate conditional logic directly within our queries. It allows you to return specific results based on certain conditions, enabling dynamic query outputs.
Syntax:-
CASE case_value
WHEN condition THEN result1
WHEN condition THEN result2
…
Else result
END CASE;
Example:
This example categorizes students’ scores into letter grades.
SELECT
student_name,
score,
CASE
WHEN score >= 90 THEN ‘A’
WHEN score >= 80 THEN ‘B’
WHEN score >= 70 THEN ‘C’
WHEN score >= 60 THEN ‘D’
ELSE ‘F’
END AS grade
FROM
student_grades;