Boolean Expressions in SELECT Clause
A boolean expression is a logical statement that returns either true or false.
A boolean expression in SELECT follows this syntax: SELECT {boolean_expression} as {alias}.
This example demonstrates a query that satisfies one numerical logical condition.
| Profits |
|---|
| true |
| true |
| true |
| false |
| true |
This example demonstrates a query that satisfies two numerical logical conditions.
| Profits |
|---|
| true |
| false |
| true |
| false |
| true |
This example demonstrates a text comparison.
| A Names |
|---|
| false |
| false |
| false |
| false |
| true |