We continue covering built-in functions and slightly covered the CASE clause.

    CASE
      WHEN some_condition_1 THEN some_action_1  -- if this condition fails,
                                                -- need to go to the next one
      WHEN some_condition_2 THEN some_action_2  -- if this condition fails,
                                                -- need to go to the next one
      WHEN some_condition_3 THEN some_action_3  -- if this condition fails,
                                                -- need to go to the next one
      ...
      ELSE escape_action                        -- if all prior conditions fail,
                                                -- need to perform this action
    END

Download the class notes for day 5.

This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.