Fastest “Get Duplicates” SQL script

This is the more direct way:

select afield1,count(afield1) from atable 
group by afield1 having count(afield1) > 1