How To Use Case Statement In SQL
Nov 25, 2019
In this article, we will learn how to use the Case statement in SQL.
In SQL, the CASE statement goes through conditions and when the first condition is met it returns a value. So, once a condition is true, it will stop reading and return the result. If no conditions are true, it returns the value in the ELSE clause (like an If Else statement).
It returns NULL if there is no ELSE part and no conditions are true.
