Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL CASE Keyword

Concept visual

SQL CASE Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

CASE Keyword

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

Formula

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);

SQL CASE Keyword

Concept visual

SQL CASE Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

CASE Keyword

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

Formula

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);

SQL CASE Keyword

SQL CASE Keyword

CASE Keyword

Previous

Next

Case

The CASE

Example

Case

THEN 'The quantity is greater than 30'

ELSE 'The quantity is under 30'

End

Example

FROM Customers

Order By

WHEN City IS NULL THEN Country

ELSE City

Previous

Next

SQL CASE Keyword

SQL CASE Keyword

CASE Keyword

Previous

Next

Case

The CASE

Example

Case

THEN 'The quantity is greater than 30'

ELSE 'The quantity is under 30'

End

Example

FROM Customers

Order By

WHEN City IS NULL THEN Country

ELSE City

Previous

Next