CASE Statement in SQL - Quick Tip

  • Wednesday, August 28, 2019
  • By DotNetKida
  • 0 Comments

CASE Statement in SQL - Quick Tip





CASE

CASE statements are used to create different outputs (Usually in the SELECT statement).
It is SQL's way of handling if-then logic.

SELECT [COLUMN_NAME] ,
             
              CASE

                     WHEN [CONDITION 1] THEN 'OUTPUT 1'

                     WHEN [CONDITION 2] THEN 'OUTPUT 2'

                     ELSE 'OUTPUT 3'
             
              END

FROM [TABLE_NAME]


In the above query, the output will be based on the conditions, if CONDITION 1 is true then the output will be OUTPUT 1, likewise, if CONDITION 2 is true then the output will be OUTPUT 2, if both conditions are false then the output will be OUTPUT 3.

You Might Also Like

0 comments