Review the following Operator reference information to help you create accurate SQL code for your segment attribute conditions.
equal to
Use the equal to operator when you want to include profiles that are exactly equal to the selected value.
...
Code Block | ||
---|---|---|
| ||
select count(*) from (
select
a."cdp_customer_id"
from "cdp_audience_1249"."customers" a
where a."gender" = 'Female'
-- set session distributed_join = 'true'
) cs |
not equal to
Use the not equal to operator when you want to include profiles that are not equal to the selected value.
Example
Match all profiles in which the gender is not Male.
SQL Example
Code Block | ||
---|---|---|
| ||
select count(*) from ( select a."cdp_customer_id" from "cdp_audience_1249"."customers" a where not coalesce(a."gender" = 'Male', false) -- set session distributed_join = 'true' ) cs |
...