SQL CASE Statement

The SQL CASE statement is similar to the IF-THEN-ELSE statement, where the CASE statement goes through different conditions and returns a value when the first condition is met. So when the condition returns true, it will stop execution and return the result. If all conditions are false, it will execute the ELSE clause and return the value. If there is no ELSE clause then it will return NULL.

CASE statement Syntax :

The syntax of the CASE statement is −

CASE
WHEN condition1 THEN result1
WHEN condition2 THEN result2
WHEN conditionN THEN resultN
ELSE result
END;

CASE statement Example :

Consider the Customer table with the following records -

TEST CASE 1 :- The following code is an example, which would fetch the all records from Customer table and change the Gender :-
where M change to Male
and F change to Female

SELECT *
CASE Gender
WHEN'M' THEN 'Male'
WHEN'F' THEN 'Female'
END
FROM Customer

The result for the respective sql query is as follows −

---

Visit :

---

Discussion