Conditional functions
Conditional functions |
Description |
Example |
|
Simple CASE format Compares the value of
|
Copy
|
Searched CASE format Returns a result based on whether the condition specified by a WHEN expression is true. CASE |
Copy
|
|
|
Returns the first value that is not NULL |
Copy
|
|
Compares two values and returns NULL if the two values are equal; otherwise, returns the first value. |
Copy
|