|
|
1. Select case statement | |
|
|
2. Case when and else | |
|
|
3. CASE: return a specified value based on a set of business logic | |
|
|
4. Use CASE in the UPDATE statement | |
|
|
5. 'Case when' statement in a procedure | |
|
|
6. Case When with else | |
|
|
7. Case when NULL | |
|
|
8. Case when with Mod and ABS() | |
|
|
9. A simple CASE takes an expression that equates to a Boolean result | |
|