Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind SQL CASE Keyword?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
1Quick choice
Which statement best captures the main point of this lesson?
2Fill blank
Complete the missing token from the example code.
___ OrderID, Quantity,3Order
Put the learning moves in the order that makes the concept easiest to apply.
The following SQL will order the customers by City.
The following SQL goes through several conditions and returns a value when the specified condition is met:
The CASE command is used is to create different output based on conditions.
Case
The CASE command is used is to create different output based on conditions.
The following SQL goes through several conditions and returns a value when the specified condition is met:
Example
SELECT OrderID, Quantity,
CASE
WHEN Quantity > 30
THEN 'The quantity is greater than 30'
WHEN Quantity =
30 THEN 'The quantity is 30'
ELSE 'The quantity is under 30'
END
FROM OrderDetails;The following SQL will order the customers by City. However, if City is NULL, then order by Country:
Example
SELECT CustomerName, City, Country
FROM Customers
ORDER BY
(CASE
WHEN City IS NULL THEN Country
ELSE City
END);