SQL logical functions are used primarily for checking (or testing) the truth of some conditions. A logical function performs a logical operation or comparison on objects and expressions and returns a boolean value −
| Sr.No. | Function & Description |
|---|---|
| 1 | CHOSE() Returns an item from the list at the specified index value. |
| 2 | IIF() Returns one of two values, depending on the boolean-expression. |
| 3 | NULLIF() Returns NULL if both expressions are equal. |
Content provided by Vista Academy