When Simple Becomes Tricky: SQL CASE Statement - Issue 132
How to apply CASE conditional expressions to specify a result when there are multiple conditions.
It’s Wednesday, and I am back with another SQL how-to for your enjoyment.
Today’s topic is not new to anyone who works with SQL - it’s the famous CASE statement! This is SQL 101, and I expect that you have mastered it since back in the early days of my newsletter. For this publication, I have 2 main objectives: brush up and re-introduce the concept of CASE statements (neither you nor I can afford becoming rusty with a foundation), as well as remind all of us how easily mistakes can slip in and become overlooked.