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.

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

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

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

This example demonstrates a text comparison.

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

j

Introducing SQL for CRM Analytics

Quick Start: Run Your First Query

SQL vs SAQL

SQL Statements

SELECT Clause

FROM Clause

WHERE Clause

Boolean Expressions in SELECT Clause

GROUP BY Clause

GROUP BY ROLLUP

GROUPING()

HAVING Clause

ORDER BY Clause

LIKE Clause

BETWEEN Operator

LIMIT Clause

FETCH Clause

OFFSET Clause

CASE Statements

COALESCE()

NULLIF()

UNION Operator

Subquery

Window Functions

Date Functions

Aggregate Functions

Math Functions

String Functions and Operators

Release Notes

Previous Versions