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.

SELECT Profit > 0 as Profits FROM "Superstore" LIMIT 5;

This example demonstrates a query that satisfies two numerical logical conditions.

SELECT Profit > 0 and Profit < 100 as Profits FROM "Superstore" LIMIT 5;

This example demonstrates a text comparison.

SELECT Customer_Name LIKE 'A%' as "A Names" FROM "Superstore" LIMIT 5;