something like this? your [memberName] can be whatever column(s) that make up a "member".
select memberName, count(*) from <yourTable> group by memberName having count(*) > 1
from yourTable as yt
(select name from yourTable where name = yt.nm and ID != yt.ID)
order by name
Be One with the Optimizer