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.