SQL Fundamentals
CASE Statements & Conditional Logic: Interview
What is the difference between searched CASE and simple CASE? Simple CASE compares one expression with several values. Searched CASE evaluates independent boole
What is the difference between searched CASE and simple CASE?
Simple CASE compares one expression with several values. Searched CASE evaluates independent boolean predicates and supports ranges, NULL tests, and compound business rules.
Mention that CASE returns a value and stops at the first matching WHEN branch.