Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
linenumberstrue
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
linenumberstrue
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

...