Distinct on one field - Access Database

SELECT T1.*FROM MyTable AS T1WHERE T1.email IN (SELECT T2.email FROM MyTable AS T2 GROUP BY T2.email HAVING COUNT(T2.email)=1 );


www.visli.com