Flow Control Statements: IF and CASE
Build on your knowledge of SQL statements by learning about controlling their flow.
We'll cover the following
With our running example of parts for car models, imagine that we are tasked to create a report for the assembly progress of each car model. That is, each car model should have one of three associated states: pending
, in progress
, or completed
. Here, pending
means that none of the three parts have been assembled; in progress
denotes one or two parts that have been assembled. Finally, completed
means that all parts have been successfully assembled.
Get hands-on with 1400+ tech skills courses.