create table test
(
email varchar2(1000),
id number ,
role varchar2(100));
insert into test values('reema@gmail.com',1,'ADMIN');
insert into test values('reema@gmail.com',2,'SECURITY');
insert into test values('sheena@gmail.com',3,'ADMIN');
which operator is to be used to get the result like below distinct email id having both role ADMIN and SECURITY
email
----------
reemapuri@gmail.com