Intersect

<< Click to Display Table of Contents >>

Navigation:  SQL features >

Intersect

Countries (B) present in both segments (A)

 

select B from sample.sheet1 where A = 'Government'
intersect 
select B from sample.sheet1 where A = 'Midmarket'