8. CASE Statement Reference

Conditional logic.

Simple CASE

Return: Value

Conditional values matching switch.

Syntax signature:CASE col WHEN val THEN res ELSE alt END

Code snippet:

python

SELECT name, CASE role WHEN 1 THEN 'Admin' ELSE 'User' END FROM users;

Expected Output:Labeled roles.

Remember: Always ensure correct syntax formatting when calling Simple CASE.

Searched CASE

Return: Value

Evaluate range predicates.

Syntax signature:CASE WHEN cond THEN res ELSE alt END

Code snippet:

python

SELECT price, CASE WHEN price > 100 THEN 'Premium' ELSE 'Standard' END FROM products;

Expected Output:Price categories.

Remember: Always ensure correct syntax formatting when calling Searched CASE.