select * from uyeler
where ad in
(select ad from uyeler group by ad having count(*)<2 )


bu şekilde dener misin