Skip to content

Instantly share code, notes, and snippets.

@wvpv

wvpv/sfmc-deduplication-with-row-number-partition.sql

Created June 21, 2017 13:44
Show Gist options
  • Save wvpv/8678ea474e0d87e6adacf8ecd17e1aee to your computer and use it in GitHub Desktop.
Save wvpv/8678ea474e0d87e6adacf8ecd17e1aee to your computer and use it in GitHub Desktop.
Download ZIP
sfmc-deduplication-with-row-number-partition.sql
Raw
sfmc-deduplication-with-row-number-partition.sql
select
x.emailaddress
, x.subscriberkey
from (
select
w.emailaddress
, w.subscriberkey
, w.insertDate
, row_number() over (partition by w.subscriberkey order by w.insertDate asc) ranking
from Welcome_Trigger w
) x
where x.ranking = 1
and x.insertDate >= convert(date,getDate()-30)
and x.insertDate < convert(date,getDate()-29)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment