GoldMine SQL Query – Show Duplicate E-mail Addresses

select address2, contsupref
from contsupp where contsupref <>” and rectype=’p’ and contact=’E-mail Address’ and contsupref in (select contsupref from contsupp group by contsupref having count(contsupref) >1) order by contsupref