What is CASE WHEN in SQL?

Question

Can anyone tell me the syntax for CASE statement in SQL?

Answer 1

CASE statements are just like the If-else statement in any programming language. In Case statements, we write the conditions, if conditions are met then it returns the result. If the condition is not met, then it returns the result in the ELSE clause. It returns null if no conditions are met and there is no ELSE clause.

Here is the CASE statement syntax in SQL:

CASE
    WHEN condition_1 THEN result_1
    WHEN condition_2 THEN result_2
    WHEN condition_N THEN result_N
    ELSE result
END;

If you want to learn SQL, you can check out this SQL tutorial blog by Intellipaat.