You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.

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)

BETWEEN