Learn how to use the CASE Expression in SQL Server. 4 Examples to Master!

In this video, I use 4 examples to teach you how to use the CASE expression.

The CASE expression allows you to use the conditional expression, much like the IF-THEN-ELSE.

------------------------------------------------------*****------------------------------------------------------------
I would appreciate if you could leave a message for other students to read, a thumbs up if you learned something new and enjoyed the video, and please consider subscribing to this channel. Thank you in advance for your consideration.

Let's help each other!
------------------------------------------------------*****------------------------------------------------------------

TIMELINE
00:00 start
00:13 Preview of each example SQL
00:43 Example 1 - TaxType
03:38 Example 2 - Case expression wrapped in Aggregate AVG function
08:18 Example 2a - Sub Query
08:41 Example 3 - Use Case express in WHERE clause
10:52 Example 3a - Use ISNULL
12:14 Example 4 - Full experience usage of the CASE expression
14:20 Example 4a - Integrate with table object

-- by : software nuggets
-- is a : sql server nugget
#softwareNuggets, #sqlServer, #caseStatement

[SoftwareNuggets]

4 Great examples for learning. Enjoy team.