Contoh Penggunaan Where, Group By dan Having Secara Bersamaan

Select field,COUNT(field) from table
where field=''
group by field
having count(field)>1