This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:features:segments:creating [2012/03/05 21:46] doc |
admin:features:segments:creating [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 23: | Line 23: | ||
>> from INDIVIDUALS | >> from INDIVIDUALS | ||
>> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | >> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | ||
- | |||
>> where STATE = 'CO' and | >> where STATE = 'CO' and | ||
- | >> CITY = 'Denver') | + | >> CITY = 'Denver'); |
- | >> with delete; | + | |
Segment PART_1 created with 37 rows | Segment PART_1 created with 37 rows | ||
Line 35: | Line 33: | ||
>> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | >> join HOUSEHOLDS on INDIVIDUALS.HOUSEHOLD = HOUSEHOLDS.HOUSEHOLD | ||
>> where STATE = 'AZ' and | >> where STATE = 'AZ' and | ||
- | >> CITY = 'Phoenix') | + | >> CITY = 'Phoenix'); |
- | >> with delete; | + | |
Segment PART_2 created with 27 rows | Segment PART_2 created with 27 rows | ||
Line 43: | Line 40: | ||
>> as (select INDIVIDUALS.$UNIQUEKEY | >> as (select INDIVIDUALS.$UNIQUEKEY | ||
>> from INDIVIDUALS | >> from INDIVIDUALS | ||
- | >> where BIRTHDATE >= 'January 1, 1990') | + | >> where BIRTHDATE >= 'January 1, 1990'); |
- | >> with delete; | + | |
Segment PART_3 created with 1,198 rows | Segment PART_3 created with 1,198 rows | ||
</code> | </code> |