Master the SQL SELECT statement part 03: CASE

This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!

This video covers using CASE in the projection to derive a column based one or more Boolean expressions. It allows us to handle IF/THEN logic, returning a value when an expression is True.

[dobro-npgs]

Thanks a lot for this great explanation. I liks youe style😊

[vinith]

Helpful, I was asked to implement histogram using SQL in an interview, I did it using Case statement :)

[adisonfryman]

Thank You for this, I am trying to figure out how to use GROUP BY with case statements using SQLSMS ....looks like a mess when I do it.