Stats

703 Contributors: 12
2017-07-18
Licensed under: CC-BY-SA

Not affiliated with Stack Overflow
Rip Tutorial: info@zzzprojects.com

Download eBook

CASE

Download sql eBook

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.

Related Examples