NOT IN

The NOT IN operator computes metric by specified attribute, excluding the listed attribute values. As a filtering operator, it excludes two or more attribute values of interest, separated by commas.

Syntax

SELECT … WHERE … NOT IN (…,…)
SELECT metric WHERE attribute NOT IN (attribute_value1, attribute_value2)

Examples

SELECT Profit WHERE Year NOT IN (2006, 2007)
SELECT Sales WHERE Quarter NOT IN (THIS, PREVIOUS)

Powered by Atlassian Confluence and Scroll Viewport.