SQL CASE

30% OFF - 9th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY9

Introduction

The CASE expression is used to implement if-then logic.

Syntax

  • CASE input_expression
     WHEN compare1 THEN result1
    [WHEN compare2 THEN result2]...
    [ELSE resultX]
    END
  • CASE
     WHEN condition1 THEN result1
    [WHEN condition2 THEN result2]...
    [ELSE resultX]
    END

Remarks

The simple CASE expression returns the first result whose compareX value is equal to the input_expression.

The searched CASE expression returns the first result whose conditionX is true.



Got any SQL Question?